RE: imp table data, but not PK indexes?

as PK comes under 'constraints' you might also have to do constraints=N also...

On Sat, 19 Jul 2003 07:04:23 -0800, "Ganesh Raja" <gans_r_at_rediffmail.com> wrote :

> Use the Indexes = N Option and Create the Index Seperatley ..
>
> AFAIK that should work ...
>
> Regards,
> Ganesh R
> HP : (+65)9067-8474
> Mail : ganesh.raja_at_logicacmg.com
>
>
> ==========================================
> All Opinions expressed are my own and do
> not in anyway reflect those of my employer
> ==========================================
>
>
> -----Original Message-----
> Guang Mei
> Sent: Saturday, July 19, 2003 10:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> I sent this yesterday but it did not seem to get posted. Anyway I am
> posting it again.
>
> 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 PK indexes later from a 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 imported in ABC_DEFAULT_TS,
> together with table data. So my question is what I can/should do so that
> I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at
> the same time?
>
> Thanks.
>
> Guang
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Guang Mei
> INET: gmei_at_incyte.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ganesh Raja
> INET: gans_r_at_rediffmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sat Jul 19 2003 - 23:09:03 CDT