Re: Export and Import and Referential Integrity Constraints

        If you have referential integrity on the database you are going to export
You can run export and not export the constraints. If you do so you should then
apply the constraints to the target databaes once it has been created.

        The problem with doing an export with constraints is that you will have
either make several import runs. For example is table A is dependent on table
B which is dependent on table C you must first import C then import B and then
(finally) import A.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/18/00, 4:30:29 PM, Boo <Boo_at_yahoo.com> wrote regarding Export and Import and Referential Integrity Constraints:

> Running Oracle 8.0.5 on Solaris 2.7.
> Is there any reasons why, when moving a database with quite a few
> referential integrity constraints to a new server, that the
> export/import option
> can't be used?
> My understanding is, if it's a fresh database built on the new server,
 

> and doesn't have existing data, than an export/import should not pose
> any problems.
 

> TIA
Received on Wed Jul 19 2000 - 00:00:00 CDT