DROP TABLESPACE error
From: Scott G. Cameron <cameron_at_acs.ucalgary.ca>
Date: 10 Jun 92 15:44:54 GMT
Message-ID: <92Jun10.154454.46190_at_acs.ucalgary.ca>
Scott Cameron, Academic Computing Services, University of Calgary Received on Wed Jun 10 1992 - 17:44:54 CEST
Date: 10 Jun 92 15:44:54 GMT
Message-ID: <92Jun10.154454.46190_at_acs.ucalgary.ca>
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
Any replies either here or by email will be greatly appreciated.
Scott Cameron, Academic Computing Services, University of Calgary Received on Wed Jun 10 1992 - 17:44:54 CEST