Re: DROP TABLESPACE error

This is just a guess but it appears that something you are trying to drop in the "including contents" includes a primary key that is referenced elsewhere. That's referential integrity for you :-)

$ oerr ora 2273
02273, 00000, "this unique/primary key is referenced by some foreign keys" // *Cause: Self-evident.
// *Action: Remove all references to the key before the key is to be dropped.

---
  /_ _   /		sequent computer system, inc.	+-----+
 / / /  /__/ __		15450 sw koll parkway		|   # |
/ / /  / \__(_/_/_/	beaverton, or  97006-6063	|     |
mary kay petersen/	mkay_at_sequent.com 		+-----+
(503)578-5817 __/

cameron_at_acs.ucalgary.ca (Scott G. Cameron) writes:




>Hello all.  I'm a neophyte oracle DBA, and I was wondering if


>anyone could give me some hints/clues/suggestions as to what

>could be causing the following error when I try to use DROP

>TABLESPACE to drop a tablespace I wish to recreate (the name of

>the tablespace has been changed to protect the innocent :) -

 


>SQL> DROP TABLESPACE xxxx INCLUDING CONTENTS;


>*

>ERROR at line 1:

>ORA-00604: error occurred at recursive SQL level 1

>ORA-02273: this 

> unique/primary key is referenced by some foreign keys





>I did take the tablespace offline before trying to drop it, and I


>did create a test tablespace with a couple of test tables which I

>SUCCESSFULLY dropped with the INCLUDING CONTENTS option.  I've

>investigated a few other ideas and poked through a few FM's, but

>so far to no avail.  I'm still plugging at it, but thought I

>might be able to pick the collective brain to save a lot of

>shooting in the dark.

 


>Any replies either here or by email will be greatly appreciated.


 


>-------------


>Scott Cameron, Academic Computing Services, University of Calgary