In many a case on the list we don't have the information to fill in to all sql
statements, like in this case the name of the tablespace. The common way to
indicate that is to frame the variable with a set or '<>' brackets. What you
need to do is replace the '<tablespace_core>' with the rean tablespace name, in
your case, from previous posts:
drop tablespace core including contents;
BTW: you should be able to simply startup your database by now. Tablespace core
should be offline.
Dick Goulet
____________________Reply Separator____________________
Author: Moucka otakar <[EMAIL PROTECTED]>
Date: 11/21/2001 10:10 AM
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
