Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export and Import and Referential Integrity Constraints
True --
However, not fully knowing every intricate detail in how Oracle Exports and
Imports, would disabling the constraints before exporting then allow the
import?
What I am asking, is would the export push the constraints as disabled, and
then import then disabled as well?
I'll start digging thru docs, but thought I would ask here as well.
Jerry Gitomer wrote:
> 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