Re: Full export and sequence behaviour in 8i

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

1. Export when there are NO transactions
2. 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:
>Hi
>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.
>
>regards
>Hrishy

Hemant K Chitale

http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l