Re: Drop Tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 21 Mar 2001 18:23:08 +0100
Message-ID: <tbhoo4nhmgft37@beta-news.demon.nl>

"Rob Simmons" <rsimmons_at_pricingdynamics.com> wrote in message news:tbhmoelbno0h4a_at_corp.supernews.com...
> I am trying to drop a table space with the following command:
>
> SQL> drop tablespace dcc_drop2 including contents cascade constraints
>
> ... And I keep getting the following errors:
>
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-02429: cannot drop index used for enforcement of unique/primary key
>
> ... How can I get Oracle to shut up and just drop the damn tablespace!?!
>
> Thanks!
>
> --
> Rob Simmons
> Director of Software Development
> Pricing Dynamics
> www.pricingdynamics.com
> 202-872-3924
>
>

Either
alter index <index_name>
rebuild
tablespace <different tablespace>
(recommended)
or
alter table <table_name> drop constraint <name of your index> (not recommended, as you will loose the constraint)

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Mar 21 2001 - 11:23:08 CST