| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: RE:
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 <moucka_at_cekia.cz> 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 bytesDatabase mounted.
SQL>
Database altered.
SQL> drop tablespace <tablespace_core> including content
*
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" <MohanR_at_STARS-SMI.com>
> 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?= <moucka_at_cekia.cz>
> 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: moucka_at_cekia.cz 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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com 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: ListGuru_at_fatcity.com (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).Received on Wed Nov 21 2001 - 13:58:24 CST
 |
 |