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
a. Export when there are NO transactionsb. 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 42Is it a expected behaviour in export import. regards Hrishy
Hemant K Chitale http://hemantoracledba.blogspot.com -- //www.freelists.org/webpage/oracle-l