Normal behaviour. If you say 'drop' to Oracle it knows it no longer has to care about it, and so does it. From then, the file has no more special for Oracle than say your background wallpaper image.
Hamid Alavi wrote: > > Hi List, > > Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the > data file also disappeared from the list of datafiles, as I know the > datafile must be removed manually Any idea? > > I am using 9.0.1 on solaris 2.8 > > Thanks, > > Hamid Alavi > > Office : 818-737-0526 > Cell phone : 818-416-5095 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
