Re: How to drop tablespace

From: Alex Shnir <shnira_at_staff.juno.com>
Date: Fri, 16 Jul 1999 12:02:49 -0400
Message-ID: <378F57A9.84ABA873@staff.juno.com>

Just keep in mind that if tablespace contains few (not all) partitions of partitioned table it fails regardless of INCLUDING CONTENTS

Don Erickson wrote:

> 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 - 11:02:49 CDT