Re: RE: How to drop a datafile ?

Thanx everybody.
i thought there would be a way to do it.

just curious .....

why is it not so ? any good reason for it ?!!!

Regards,
Jp.

30-10-2003 02:34:26, Jared.Still_at_radisys.com wrote:
> That won't actually do what you're implying. Checking the docs would prove
> helpful.
>
> From the SQL ref:
>
>
> If the database is in NOARCHIVELOG mode, you must specify the DROP clause to
> take a datafile offline. However, the DROP clause does not remove the
>
> datafile from the database. To do that, you must drop the tablespace in
> which the datafile resides. Until you do so, the datafile remains in the
>
> data dictionary with the status RECOVER or OFFLINE.
>
>
> If the database is in ARCHIVELOG mode, Oracle ignores the DROP keyword.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

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: 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).