Hi
use in mount state of database:
alter database datafile '/data/db/database/core.dbf' offline drop;
Regards
Ivo Libal
Moučka Otakar
<moucka@cekia An: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
.cz> Kopie:
Gesendet von: Thema:
root@fatcity.
com
11/21/2001
02:40 PM
Bitte
antworten an
ORACLE-L
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: [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).
