loading table data, but not PK indexes?

From: Guang Mei <gmei_at_incyte.com>
Date: Fri, 18 Jul 2003 13:22:11 -0400
Message-Id: <25956.338485@fatcity.com>

Hi,

I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace "indexes" (because I can create them later from script), So I have this running before imp data

alter user ABC quota 0 on indexes;
alter user ABC quota unlimited on ABC_DEFAULT_TS;

I found that this way the PK indexes are loaded in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time?

Thanks. Received on Fri Jul 18 2003 - 12:22:11 CDT