Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: 8.1.5 upgrade paths to 10.2.x
To the OP,
When you pre-create objects, make sure you exclude sequence creation at that time. Sequences that are pre-created are NOT updated during re-import. If you do precreate all the objects, then either drop the sequences in the target prior to the data import or make sure you sync up the Seq CURRVALs.
> One option is using export full with no rows and import full witihout rows
> to generate the database structure so you dont have to worry abour grants,
> after that just run several parallel imports per schema
-- John Kanagaraj <>< DB Soft Inc http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** 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-lReceived on Wed Oct 17 2007 - 11:07:20 CDT
![]() |
![]() |