Re: IMPORT

From: Ronald <ronr_at_wxs.nl>
Date: Wed, 27 Jan 1999 6:20:16 +0100
Message-ID: <01HW.B2D460A000005FAA1273ADA0@news.wxs.nl>

On Tue, 26 Jan 1999 17:01:40 +0100, xx wrote (in message <78kot6$ej4_at_romeo.logica.co.uk>):
>
> Hi there,
>
> When importing data-only into tables without constraints on them the process
> of importing seems to create PK indexes when I've specified in the PAR file
> INDEXES=N.
>
> What's going on here??? How can I stop this happening?
>
> Thanks a lot
>
> Igor
>
>
>
>

You have to use exp with constraints=no to export the data only. This is the only way not to create indexes at all during import. Next you should use exp rows=no and import the resulting file with ignore=y to get the constraints and indexes back.

Cheers,
--

Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html

        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl

Received on Tue Jan 26 1999 - 23:20:16 CST