RE: RE:

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Wed, 21 Nov 2001 08:33:17 -0800
Message-ID: <F001.003CAC22.20011121080331@fatcity.com>

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: =?iso-8859-2?q?Mou=E8ka=20Otakar?= 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
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------