Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help With exp and DRI

Re: Help With exp and DRI

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Tue, 13 Oct 1998 13:09:54 +0100
Message-ID: <36234312.A9BB953@DeutschePost.de>


Hi,

you have to disable all constraints referencing this table. That means, better export when nobody works in database ... How to check - are there ugly constraints or not:

select
OWNER,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,DELETE_RULE,STATUS from dba_constraints
where R_CONSTRAINT_NAME in
(select CONSTRAINT_NAME from dba_constraints where TABLE_NAME='TABLE_TO_EXPORT');

If
there is no output or DELETE_RULE='NO ACTION' then you can drop the table and reimport it
else
disable first the constraints in the output lines.

T. Borchert

Rob Forster wrote:
>
> I have some questions related to using the export utility.
>
> When using the export utility to rebuild a table with child tables (ie.
> foreign key references), how is this done?
>
> Can I export the parent table only and then rebuild the primary key and all
> its non-unique indexes or do I have to export the parent and all its
> children and their indexes.
>
> Also, is there a way to do this while the database is open and available to
> users. How would one go about this using a lock table command and then
> invoking export?
>
> Thanks,
> Rob.
Received on Tue Oct 13 1998 - 07:09:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US