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

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

Re: Import Question

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: 1999/11/05
Message-ID: <MrjU3.1593$435.40466@news.hananet.net>#1/1

<amerar_at_ci.chi.il.us>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:7vsb21$u8c$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.

Oracle import utility is operate like this

1. create table without any constraint(or make them disabled)
2. insert all rows
3. import constraints, triggers, previliges etc...
Received on Fri Nov 05 1999 - 00:00:00 CST

Original text of this message

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