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