Re: Help on EXPort
From: Dick Allie <dallie_at_ionet.net>
Date: 1997/07/25
Message-ID: <33D8A54C.75AA_at_ionet.net>#1/1
Date: 1997/07/25
Message-ID: <33D8A54C.75AA_at_ionet.net>#1/1
Forbesmail wrote:
>
> In EXP do the triggers and constrains also get exported. Or is this
> something seperate which I have to add to the newly imported database.
>
> Thanks in advanace,
> Al Forbes
> forbesmail_at_aol.com
If you do an export by owner then all objects that belong to that owner
are exported. You have to be careful on imports. If a trigger is
active on one table that populates another table you could end up with
duplicate records. It's best to disable the triggers before the export
and enable them after the import.
The option constraints= y or n determines if you get constraints or not.
Dick Allie Received on Fri Jul 25 1997 - 00:00:00 CEST