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