| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to Drop a Table
Ken,
If you are going to reuse the database, make sure that you have a TEMP tablespace of some sort available to use. Perhaps you had a TEMP and a TEMP01 or something like that. Then when you dropped the TEMP tablespace, you should still be o.k. But if you only had that one TEMP tablespace, then you're going to have to recreate it, if you want to continue using your database.
Hope that wasn't already blatently obvious to you. If it is, never mind.
Cherie Machler
Oracle DBA
Gelco Information Network
Ken Janusz
<ken.janusz_at_su To: "'Cherie_Machler_at_gelco.com'"
<Cherie_Machler_at_gelco.com>
fsys.com> cc:
Subject: RE: How to Drop a Table
11/20/01 07:30
AM
I'm getting rid of the contents so I can use it for another DB for my DB conversion. I found a way around it via DBA Studio. Why I need to reuse this DB is a long story.
Thanks,
Ken
-----Original Message-----
Sent: Tuesday, November 20, 2001 7:34 AM To: ORACLE-L_at_fatcity.com Cc: ken.janusz_at_sufsys.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
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-LReceived on Tue Nov 20 2001 - 08:29:10 CST
(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).
 |
 |