Re: Manuell deleted Datafile

It sounds good, but i can't go to the database with an sql-tool like
"sqlplus". The errors are :
SQL*Plus: Release 9.0.1.0.1 - Production on So Jul 4 15:22:40 2004
(c) Copyright 2001 Oracle Corporation. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

What now ? I can't connect to the database, but oracle is started with an
error of the deleted files. (It wasn't system_01.dbf :-) )

"Dave" <david.sharples3_at_ntlXworld.com> schrieb im Newsbeitrag
news:y6KFc.738$s21.722_at_newsfe2-gui.ntli.net...
>> "Mario Koch" <m.koch_at_md-netz.de> wrote in message> news:cc79b8$n4r$02$1_at_news.t-online.com...> > I have manually deleted a datafile (.dbf) from the oracle database. Now> the> > database never start.> > What can I do to correct these problem ? This was a tablespace for> testing> > and it can complete delete from database.> >> > and others:> > Whow can i delete a datafile from a tablespace with sql-comand.> >> > greetings mario> >> >>> Well if you dont need it, do this>> shutdown the database>> startup mount>> alter database datafile 'full_path_to_data_file' offline drop;>> alter database open;>> drop tablespace xxx (where xx is the tablespacename the data file was> part of)>> I sincerely hope this wasnt system_01.dbf or something like that or you
are
> screwed.>>> You can't delete a datafile from anywhere, you have to drop the tablespace> it is part of>> you can do this by doing drop tablespace xxx including contents and> datafiles; (9i) - this will remove the os file for you>>Received on Sun Jul 04 2004 - 08:26:01 CDT