Re: RE:

From: Moucka otakar <moucka_at_cekia.cz>
Date: Wed, 21 Nov 2001 10:59:11 -0800
Message-ID: <F001.003CAF34.20011121101019@fatcity.com>

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" <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).

Received on Wed Nov 21 2001 - 12:59:11 CST