Re: Export Import and disabling constraints

Hi Starous,

        If you are importing into an existing table (IGNORE=Y), then yes... constraints are checked, triggers fire and indexes are maintained. You can disable constraints via an ALTER TABLE command prior to import then re-enable them afterwards.

If the table does not exist prior to import (as would be the case with the default IGNORE=N), then no constraint checking, trigger or index maintenance is done during load because all these items are created after the table is loaded.

Regards, George Claborn (VLDB Utilities, ORacle Corp)

On 8 Dec 1998 17:00:05 GMT, starek_at_pluto.spsselib.hiedu.cz (Roman Starek) wrote:

>Hi all
>
>
> I have little problem. I need to export and then import database schema.
>I need to export constraint but Oracle during import checks all constraints are
>valid. This process take much time. Is there any way to create new constraints
>without spending much time during controlling the constraint ?
> My import is about 2 hours but checking constraint is about 4 hours.
>One way is to use SQL loader, or export import in direct path mode, but this way is
>inpossible to me.
>
> Thanks for any advice.
>
>
> Starous
>
Received on Thu Dec 10 1998 - 05:53:50 CST