Re: separated import indexes and data

From: SW <flyhorse_127_at_hotmail.com>
Date: 23 Nov 2004 01:57:34 -0800
Message-ID: <1101203854.307166.229590@c13g2000cwb.googlegroups.com>

You need to do in both SQL*PLUS & imp to get it done.

sql> alter user xxx quota 0 on index_tbs quota unlimited on data_tbs default tablespace data_tbs;
$ imp rows=y indexes=n constraints=n

sql> alter user xxx quota 0 on data_tbs quota unlimited on index_tbs default tablespace index_tbs;
$ imp rows=n ignore=y indexes=y constraints=y
sql> alter user xxx quota unlimited on data_tbs quota unlimited on index_tbs
default tablespace data_tbs;

complete! Received on Tue Nov 23 2004 - 03:57:34 CST