Antwort:

From: <Ivo.Libal_at_knapp-systems.com>
Date: Thu, 22 Nov 2001 03:21:14 -0800
Message-ID: <F001.003CB72B.20011122025519@fatcity.com>

Hi
use in mount state of database:
alter database datafile '/data/db/database/core.dbf' offline drop; Regards
Ivo Libal

                                                                                       
                            
                    Mou&ccaron;ka Otakar                                                      
                            
                    <moucka_at_cekia        An:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    .cz>                 Kopie:                                        
                            
                    Gesendet von:        Thema:                                        
                            
                    root_at_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: 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: Ivo.Libal_at_knapp-systems.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