Re: Full export and sequence behaviour in 8i

From: Hemant K Chitale <>
Date: Fri, 13 Mar 2009 22:22:57 +0800
Message-Id: <>

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:
>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 Chitale

Received on Fri Mar 13 2009 - 09:22:57 CDT

Original text of this message