I have next problem , syntax its ok.
SQL> Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace <tablespace_core> including content;
ORACLE instance started.
Total System Global Area 178213024 bytes
Fixed Size 73888 bytes
Variable Size 161189888 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
SQL>
Database altered.
SQL>
Database altered.
SQL> drop tablespace <tablespace_core> including content
*
ERROR at line 1:
ORA-02216: tablespace name expected
Dne st 21. listopad 2001 17:03 jste napsal(a):
> Jaysus, note the date and time. It's a freaking miracle.
>
> ;-)
>
> -----Original Message-----
> Sent: Wednesday, November 21, 2001 10:54 AM
> To: Mohan; Ross; Multiple recipients of list ORACLE-L
>
>
> OOPS! sorry, your right
>
> ____________________Reply Separator____________________
> Author: "Mohan; Ross" <[EMAIL PROTECTED]>
> Date: 11/21/2001 7:40 AM
>
> "cascade"? probably more abject ignorance on my part, but wasn't it
> "including contents"?
>
> -----Original Message-----
> Sent: Wednesday, November 21, 2001 10:15 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Startup mount
> alter database datafile '/data/db/database/core.dbf' offline drop;
> alter database open;
> drop tablespace <tablespace_name> cascade;
>
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
> Date: 11/21/2001 5:40 AM
>
> Hello
> I need a help with one problem. In the Oracle version 8.1.7 I've deleted
> a "tablespace" in the Linux, but before this I did't use a function "
> Drop".
> After reboot a database, there was a error:
> ERROR at line 1:
> ORA-01116: error in opening database file 7
> ORA-01110: data file 7: '/data/db/database/core.dbf'
> ORA-27041: unable to open file
> Linux Error: 2: No such file or directory
> Additional information: 3
> Is there a some re-step to drop "tablespace" and then regulary delete
> this object and restart the database ?
> Thanx a lot for your answer.
>
> Ota Moucka
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Moucka otakar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
