Re: Oracle Export question.

On Sun, 29 Mar 1998 16:17:49 -0600, hpdba <hpdba_at_yahoo.com> wrote:

>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?
>
>I have not found much discussion on this in the DBA admin books I have.
>
>Thanks in advance.

In order to get your table dropped, you have to:

• first drop all foreign key constraints that reference table_a yourself
• or issue 'DROP TABLE table_a CASCADE CONSTRAINTS', the result of which will be the same.

Please note that if you drop a table, all other objects that depend on it, e.g. views, stored procs, etc will be invalidated and will need recompilation later on. Furthermore you should plan on how to restore grants after reimporting.

HTH
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net