Oracle-L: RE: How to drop a datafile ?

From: Venu Gopal <venu.andem_at_wipro.com>
Date: Wed, 29 Oct 2003 05:09:32 -0800
Message-ID: <F001.005D4F00.20031029050932@fatcity.com>

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

Received on Wed Oct 29 2003 - 07:09:32 CST