Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to drop tablespace

How to drop tablespace

From: Don Erickson <derickso_at_garden.csc.calpoly.edu>
Date: 16 Jul 1999 08:36:34 -0700
Message-ID: <7mnji2$rvn@garden.csc.calpoly.edu>

Need to drop a tablespace including contents. Tablespace contains over 300 tables but little data. Tables were created by a student class so I have no knowledge of how things were organized. This is Oracle 8.0.5 running on solaris. My old method of cleaning up the student tablespace of: drop tablespace data_st including contents cascade constraints doesn't work. It returns the error: cannot drop nested tables.

Nothing needs to be saved. I just need to drop the tablespace and clean up the data dictionary.

Thanks in advance for any help. Received on Fri Jul 16 1999 - 10:36:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US