Re: How to Drop a Table

From: <Cherie_Machler_at_gelco.com>
Date: Tue, 20 Nov 2001 06:02:20 -0800
Message-ID: <F001.003C9482.20011120053517@fatcity.com>

Ken,

They should already be gone if they were created in the USERS tablespace. When you query for them, do you see them at all? If you can't see them in the DBA_TABLES view then they were implicitly dropped when you dropped the users tablespace.

Do you need the TEMP tablespace for anything else? Are there any other tablespaces in that database that still require the TEMP tablespace? Or are you literally getting rid of the entire database?

Cherie Machler
Oracle DBA
Gelco Information Network

                                                                                       
                          
                    Ken Janusz                                                         
                          
                    <ken.janusz_at_su       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>     
                    fsys.com>            cc:                                           
                          
                    Sent by:             Subject:     How to Drop a Table              
                          
                    root_at_fatcity.c                                                     
                          
                    om                                                                 
                          
                                                                                       
                          
                                                                                       
                          
                    11/20/01 06:45                                                     
                          
                    AM                                                                 
                          
                    Please respond                                                     
                          
                    to ORACLE-L

I am deleting the demo DB. First I dropped the tablespaces - USERS and TEMP. Now I want to drop the four tables. However, when I tried it I get an error that these tables do not exist. I guess I should have dropped the tables first then the tablespaces. So, how do I drop these tables?

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: ken.janusz_at_sufsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: 
  INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Nov 20 2001 - 08:02:20 CST