Re: how to drop a tablespace

In article 25311_at_rat.csc.calpoly.edu, derickso_at_garden.csc.calpoly.edu (Don Erickson) writes:
>
> I need to drop several tablespaces that are no longer used.
> The command "drop tablespace ts3 including contents" fails with
> a warning about the presence of foreign keys.
>
> There are several hundred users and over 2000 tables involved.
> All data has been removed. Now I need to clean up the data
> dictionary.
>
> I get the same warning regardless of tablespace online/offline,
> and connected as sys, system, or myself.
>
> Any help, ideas, or suggestions greatfully accepted.
>
> Don E.
>

Try: drop tablespace ts3 including contents cascade constraints;

Beverly Zygmunt
Oak Ridge National Lab Received on Tue Dec 28 1993 - 13:52:21 CET