Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import Question

Re: Import Question

From: John Chiu <johnc_at_relsol.com>
Date: 1999/11/04
Message-ID: <7vsfou$ma1$1@newsmaster.pathcom.com>#1/1

Try import in two steps:
Import with full=y row=n to create all database structures with no data. then import with full=y row=y ignore=y to import data and ignore error

HTH John Chiu

amerar_at_ci.chi.il.us wrote in message <7vsb0s$u7v$1_at_nnrp1.deja.com>...
>
>
>Hello,
>
>I am trying to import into a brand new database. This is a full
>database import. When the import is running, how can I disable all the
>constraints and indexes so I will not get any errors with foreign keys
>and such.
>
>This is an empty database with no tables existing yet......
>
>Thanks,
>
>Arthur
>amerar_at_ci.chi.il.us
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Nov 04 1999 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US