Re: Oracle Export question.

From: Sanjay Mathew <alsm1_at_micro.lucent.com>
Date: 1998/03/30
Message-ID: <351FE854.C92EDEB1@micro.lucent.com>#1/1

The drop on table A will never work as there is a table B refers to table A via the constraint.
What you need to do is to

1) drop the ref constraint of table B.
2) Drop and reimport A
3) Build the ref constraint again.

Hope this answers
Cheers
Sanjay Mathew
Oracle 7 Certified DBA

hpdba 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.
Received on Mon Mar 30 1998 - 00:00:00 CST