Re: Drop constraint in PL@SQL

From: MaisonBorniol <maisonborniol_at_nomade.fr>
Date: 5 Nov 2003 23:25:43 -0800
Message-ID: <29f4fc84.0311052325.b62ccf4@posting.google.com>

Thanks a lots,

What I don't understand is wgy I have this error :

ERREUR line 1 :
ORA-02273: unique/primary key is refernced by foreign keys ORA-06512: line 16

I'm doing this script in order to drop all my tables, but for that I have to drop all my constraint. And when I try to de that I have this error.

How to drop all table (with foreign key references) for one user ?

I don't want to drop the tables with a specific order....I would like to have a generic script.

Thanks a lot for any help ! Received on Thu Nov 06 2003 - 01:25:43 CST