Home » RDBMS Server » Server Administration » Integrity constraints while migrating
Integrity constraints while migrating [message #204323] Mon, 20 November 2006 02:57 Go to next message
qwerty_infy
Messages: 2
Registered: November 2006
Junior Member
Hi
I want to migrate my data from my old Db on 8i to 10g, and am trying to use import /export.
Cna someone gove some information about the integrity constraints to be taken care while migration like foreign key etc.
Will these constraints and value limits pose any problem at time of migration
Re: Integrity constraints while migrating [message #204354 is a reply to message #204323] Mon, 20 November 2006 05:07 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The import should take care of this - it recreates the integrity constraints at the end of the import.
If you are only exporting/importing a subset of the schemas in your Db, and you have cross schema RI constraints, then you could conceivably hit problems, but your testing will show you this.
Previous Topic: Migration from 8i to 10g
Next Topic: Extent Allocation Sequence
Goto Forum:
  


Current Time: Sat Dec 03 17:55:32 CST 2016

Total time taken to generate the page: 0.04111 seconds