maisonborniol_at_nomade.fr (MaisonBorniol) wrote in message news:<29f4fc84.0311052325.b62ccf4_at_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 !
You'll need to either disable or drop all foreign key references
first, then you should be able to drop the tables in any order you
want.
Received on Thu Nov 06 2003 - 09:29:21 CST
