Re: Full export and sequence behaviour in 8i
Date: Fri, 13 Mar 2009 22:22:57 +0800
Even a CONSISTENT=Y is not likely to apply to Sequences. Good Practices when using Export-Import for upgrades/migrations to new servers have been to
- Export when there are NO transactions
- Generate a CREATE SEQUENCE script with values higher than the current highest and use such a script at the target
Hemant K Chitale
At 05:46 PM Friday, hrishy wrote:
>We have exported 8i database and imported into 10g using full=y.
>After this i notice useres complaining about unique constraint
>violation as the sequence numbers have a value less then the primary
>key in some of the tables.Example the seq number is 38 and the table
>pk has a value of 42
>Is it a expected behaviour in export import.
Hemant K ChitaleReceived on Fri Mar 13 2009 - 09:22:57 CDT