RE: Drop Tablespace

From: Ramon E. Estevez <restevez_at_blh.com.do>
Date: Tue, 01 Jul 2003 13:42:19 -0700
Message-ID: <F001.005BD8A9.20030701132800@fatcity.com>

There's a new feature in 9i that can remove the os file also

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994

-----Original Message-----
Jose Luis Delgado
Sent: Tuesday, July 01, 2003 5:13 PM
To: Multiple recipients of list ORACLE-L

It dissappered from the data dict...

but it should exist at os level...

you need to rm it...

check it...

HTH
JL

• Hamid Alavi <[EMAIL PROTECTED]> wrote:
  > Hi List,
  >
  > Today I have dropped a big tablespace(4 Gig) as soon
  > as I dropped it the
  > data file also disappeared from the list of
  > datafiles, as I know the
  > datafile must be removed manually Any idea?
  >
  > I am using 9.0.1 on solaris 2.8
  >
  > Thanks,
  >
  > Hamid Alavi
  >
  > Office : 818-737-0526
  > Cell phone : 818-416-5095
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Hamid Alavi
  > INET: [EMAIL PROTECTED]
  >
  > 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: [EMAIL PROTECTED] (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).
  

  ---

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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 Tue Jul 01 2003 - 15:42:19 CDT