How to split indexes from data?

From: Mike Adams <mikea_at_best.com>
Date: 2000/05/02
Message-ID: <390fc40d$0$218@nntp1.ba.best.com>#1/1

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 Tue May 02 2000 - 00:00:00 CDT