Hi All,
Can anyone tell me how to change the default tablespace for indexes? I am using oracle 8.1.7 on Solaris.
Regards
[Edited by sudip on 05-24-2002 at 01:50 AM]
Printable View
Hi All,
Can anyone tell me how to change the default tablespace for indexes? I am using oracle 8.1.7 on Solaris.
Regards
[Edited by sudip on 05-24-2002 at 01:50 AM]
partitioned index?
alter index xxxx modify default attribute tablespace yyyy
Sorry, but it is non partiotioned index.
You can use
ALTER INDEX indx_name REBUILD tablespace ts_name;
Thanx a lot for the help. I missed that part in ORacle documentation.
Thanx again