Re: Full export and sequence behaviour in 8i

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Sun, 15 Mar 2009 08:01:22 +0200

I beg to differ.
Having sequences out of order means that you lost some data.
In his example 4 rows are missing, each one for a multi million order that disappear from the books.

You must stop transactions against the original database in cases of migrating the database to a new server.

Adar Yechiel
Rechovot, Israel

Hemant K Chitale wrote:

b. Generate a CREATE SEQUENCE script with values higher than the current highest and use such a script at the target


Other related posts: