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_at_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 - 18:57:51 CEST

Original text of this message