| Integrity constraints while migrating [message #204323] |
Mon, 20 November 2006 02:57  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
