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
Messages: 2
Registered: November 2006
Junior Member
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
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: Extent Allocation Sequence
Next Topic: Migration from 8i to 10g
Goto Forum:

Current Time: Sun Aug 20 21:38:08 CDT 2017

Total time taken to generate the page: 0.12410 seconds