Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: DROP TABLESPACE error

Re: DROP TABLESPACE error

From: Scott G. Cameron <cameron_at_acs.ucalgary.ca>
Date: Thu, 11 Jun 92 16:57:51 GMT
Message-ID: <92Jun11.165751.57326@acs.ucalgary.ca>

Thanks to all for the help. Trying to drop a primary key before the tables referencing it as a foreign key was indeed the problem. Knowing that constraints aren't enforced in the data in version 6, it didn't come to mind right away that the data dictionary might actually be paying some heed to the constraints.

It seems that ...INCLUDING CONTENTS attempts to drop the tables in the order they were defined, which of course is the wrong order if there are any referential constraints. A drop order of reverse-defined would probably be a wiser approach.

-- 
Scott Cameron, Academic Computing, University of Calgary
email: cameron_at_acs.ucalgary.ca
Received on Thu Jun 11 1992 - 11:57:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US