Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to drop tablespace
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
![]() |
![]() |