PK is a constraint too & constraints=Y by default.
--- 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 - 14:20:59 CDT
