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

From: Mudhalvan, Moovarkku <mmudhalvan_at_gcrejapan.co.jp>
Date: Tue, 28 Oct 2003 21:09:24 -0800
Message-ID: <F001.005D4D92.20031028210924@fatcity.com>

Prem..

Why don't you install Enterprise manager in any one of your client .. Login as Stand Alone.. And you can delete the same

-----Original Message-----
Sent: Tuesday, October 28, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L

Guys,

it's oracle 9.2.0.3/Win2K.

say for some reason (NOT recovery):
i want to drop a datafile from a tablespace which has more than 1 datafile.how to do it ?

Doc 111316.1 says u need to drop the tablespace or exp/imp the objects in the tablespace.

your ideas please.

Jp.

--

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mudhalvan, Moovarkku
INET: mmudhalvan_at_gcrejapan.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------