Re: Oracle Export question.

Don't pay attention to that. I confused drop with truncate.

Julio escribi :

> Before you drop table A you can disable the integrity constraint in
> table B.
> Do:
> Select constraint name from user constraints
> where ...;
>
 

> This gives you the constraint name.Execute now:
>
 

> Alter table B disable constraint <constraint name>;
>
 

> And now you can drop table A.
>
 

> After import, just execute:
>
 

> Alter table B enable constraint <constraint name>;
>

Regards.

-- 

Julio Negueruela
DBA    Servicio Inform tico
Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180
mailto:julio.negueruela_at_si.unirioja.es