Re: Full export and sequence behaviour in 8i
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Sun, 15 Mar 2009 08:01:22 +0200
Message-id: <49BC99B2.8090301_at_inter.net.il>
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.
Date: Sun, 15 Mar 2009 08:01:22 +0200
Message-id: <49BC99B2.8090301_at_inter.net.il>
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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 15 2009 - 01:01:22 CDT