Drop tablespace with nested tables

From: Don Erickson <derickso_at_garden.csc.calpoly.edu>
Date: 3 Aug 1999 09:17:39 -0700
Message-ID: <7o74n3$oqr@garden.csc.calpoly.edu>

I need to drop a tablespace containing nested tables. The command "drop tablespace data_st including contents cascade constraints" returns the error ORA-22914. A check of the docs says drop of nested tables not supported and the parent table must be dropped.

The tablespace was used by a class of database students and at this point contains over 300 tables. The structure and the dependancies of the tables is unknown as each student developed his own version of what a database should look like.

Nothing in the tablespace needs to be saved. It just needs to be cleaned up so we're ready for the next class.

This is Oracle 8.0.5 on a Solaris 2.5.1 server.

Thanks in advance for any help.

Don Erickson, Lab Manager Received on Tue Aug 03 1999 - 11:17:39 CDT