indexes

[dragon99]

Hi, all
I have question here,
I am using oracle 8.1.5 right now. when I create a user say Scott, and use user Scott to create schemas. When the schemas are created, the indexes are created on the colunms which are primary keys and they are in the format of 'SYS.xxxxxxxx'. Now my question is where this index resides on? on the table SYSTEM? or on the user Scott's default tablespace? If it is in SYSTEM tablespace, is it possible to rebuild it on another tablespace INDEX? Thanks for help.

[jgmagnus]

You can rebuild any index onto any schema/tablespace/datafile you like. However, be aware that you need to add permissions and quota for the current owner to rebuild onto the separate schema.

You can look up the owner of any index using the dba_indexes table. This table can give you a good deal of data.

If you have more questions, let me know.

- Magnus

[Hakimca]

Hi,

The indexes are created on the user Scott's default tablespace.
You can move the indexes to an other tablespace by issuying the following statement.
ALTER INDEX <index name> REBUILD TABLESPACE <tablespace name>.


Hope this help.

[dragon99]

Thanks very much.