Re: How to split indexes from data?

Try
alter index index_name rebuild tablespace new_tablespace_name;

command computes some default statistics!? (don't know, why), so you can delete statistics with
alter index index_name delete statistics;

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 Wed May 03 2000 - 00:00:00 CDT