RE: How to drop a datafile ?

From: Craig Richards <craigdba_at_hotmail.com>
Date: Wed, 29 Oct 2003 01:24:25 -0800
Message-ID: <F001.005D4D9D.20031029012425@fatcity.com>

I don't beelive you can drop a datafile from a tablespace, you have to drop the tablespace, just reaize the datafile to 1M if space is the problem

Regards

>From: Prem Khanna J <jprem_at_kssnet.co.jp>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: How to drop a datafile ?
>Date: Tue, 28 Oct 2003 22:19:24 -0800
>
>doc 111316.1 doesn't mention about using
>OEM for the same.
>
>so i hope it cannot be done with OEM.
>am i right LIST ?
>
>so how do i do it from sqlplus ?
>
>TIA.
>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).

---

Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Richards
  INET: craigdba_at_hotmail.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 - 03:24:25 CST