Re: Oracle Export question.

hpdba escribió:
>
> Hi guys,
>
> Here's a hypothetical situation.
>
> I have a table (table-A) that needs to be exported and imported with
> compress=Y to reduce the number of extents. I plan to drop the table
> before importing it so the import creates a large initial extent.
> Another table (table-B) has a referential integrity contraint that
> refers to the table I want to export/drop/import.
>
> If I perform the export, drop table, and import as planned will the
> integrity constraint in table-B be lost because I dropped table-A during
> the process? If so, will the constraint in table-B be restored when I do
> the import for table-A?

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>;  

> I have not found much discussion on this in the DBA admin books I have.
>
> Thanks in advance.

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