default index

[ampearce]

Hi,

Im trying to find a command to specify a default index tablespace, i know i can use 'alter tablespace rebuild' to move them but is there any way i can get oracle to automatically recognise that it should use a particular index tablespace?

Thanks
Aidan.

[carp]

Well, you can specify a default tablespace for any given user. However, this will cause Oracle to build indexes, tables, etc in this tablespace if you don't specify otherwise. As for specifying different tablespaces for different segment types - No, you can't do it. So if you want an index built in a given tablespace, you will have to specify the tablespace when you create the index.