Re: How to split indexes from data?

Another way is a used based two-step Import . First alter the default tablespace of the importing user e.g. DATA. Then import the data with rows=Y indexes=N. Then alter the default tablespace to the index tablespace and revoke (important!!!) the quotas on the old tablespace and grant quotas on the index tablespace e.g. INDEX. Then do an import with rows=N and indexes=Y. Based on the revoked quotas on the DATA tablespace import uses the default tablespace INDEX for creating the indexes.

Mike Adams wrote:

> I have a new database that I created and will load using an export from
> another database. The indexes in the "source" database are stored in the
> same tablespace as the tables. In my new database I want to separate the
> indexes and store them in the INDEX tablespace. Is there any easy way to do
> this? (I'm running Oracle 8i)
>
> And going forward, how do I enforce the splitting of the indexes from the
> tables. I know that the "create table" and "create index" commands can
> specify the tablespace for the index, but is there any way just to set a
> default for all users so they don't have to worry about it?
>
> Please 'cc' mikea_at_best.com on responses as I'm not able to check newsgroups
> from work.
>
> Thanks in advance for ANY help!!!
>
> Mike
Received on Mon May 08 2000 - 00:00:00 CDT