RE: Moving database from HP to IBM-AIX

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 28 Oct 2005 15:24:24 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKIEMDHCAA.mwf@rsiz.com>

Good point. Adjusting sequences is a required part of the mucking around. I should have mentioned along with triggers and constraints.

Rightsizing, Inc.
Mark W. Farnham
President
mwf_at_rsiz.com
36 West Street
Lebanon, NH 03766-1239
tel: (603) 448-1803

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John Kanagaraj Sent: Friday, October 28, 2005 2:03 PM
To: mwf_at_rsiz.com; dubey.sandeep_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Moving database from HP to IBM-AIX

> Run the no-rows import. Muck around and disable what you need to so
you can start the big boys loading in parallel

Mark/Sanjay,

One of the "gotchas" with a no-rows import (pre-create objects to save time) followed by a full data export/import to move data across platforms is this: The values in Sequences are NOT re-imported when you re-import the data. So they will remain at the values they were when you did the first no-data import. This can become vewy, vewy nasty in an ERP application (need I say 11i) which deals a lot with sequences that change quite rapidly and is used to mark things like Checks and Invoices that go out to customers.

The solution is to make sure that sequence number are refreshed / reset to the correct values at the end *manually*.

>From someone who narrowly escaped this "gotcha"

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Fear connects you to the Negative, but Faith connects you to the Positive! I Jn 4:18

The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-l

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

Received on Fri Oct 28 2005 - 14:28:10 CDT