RE: How to drop a datafile ?

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.

Jared

"Venu Gopal" <venu.andem_at_wipro.com>
Sent by: ml-errors_at_fatcity.com
 10/29/2003 05:09 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: How to drop a datafile ?

Well, you an actually move all your objects from this datafile into a different datafile (read it as different TS) and then offline drop the datafile.
This will ensure that users don't get the error 'xxx.dbf file is currently inacessible' message.

Cheers!
Venu

-----Original Message-----
Prem Khanna J
Sent: Wednesday, October 29, 2003 4:34 PM To: Multiple recipients of list ORACLE-L

Thanx Sinardy & Rachel.

so,the only way is as what Sinardy said. is that so ?

Regards,
Jp.

29-10-2003 19:44:25, Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
>The doc is right. You cannot drop a single datafile from a tablespace.

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


**************************Disclaimer************************************

Information contained in this E-MAIL being proprietary to Wipro Limited is 

'privileged' and 'confidential' and intended for use only by the 
individual
 or entity to which it is addressed. You are notified that any use, 
copying 
or dissemination of the information contained in the E-MAIL in any manner 
whatsoever is strictly prohibited.

***************************************************************************
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Venu Gopal
  INET: venu.andem_at_wipro.com

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

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