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.