Re: Using INDEXES=N in imp

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 13 May 2002 06:46:57 +0200
Message-ID: <09hudu0q11g48ennedrpob8kel6gferu3s@4ax.com>

On Sun, 12 May 2002 23:45:07 -0400, C Chang <cschang_at_maxinter.net> wrote:

>I put INDEXES=N in imp script as
>imp sys/password d:\dump_file.dmp fromuser=me touser=me indexes=n
>commit=y d:\dump_file.log
>aftr the import has finished, I still saw the old indexes ( using the
>DBA studio), Why?
>
>C Chang

Indexes=n doesn't apply to PK and unique constraints

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun May 12 2002 - 23:46:57 CDT