At 06:14 AM 7/19/2003 -0800, you wrote:
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).