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).
Received on Tue Jul 01 2003 - 15:31:47 CDT
