Hi all,
The dba before me created an index on USERS table and put it on USERS tablespace. I believe the index created should be in INDEX TABLESPACE.
How can move or relocate the index to INDEX tablespace?
Thank you
Ablakios
Printable View
Hi all,
The dba before me created an index on USERS table and put it on USERS tablespace. I believe the index created should be in INDEX TABLESPACE.
How can move or relocate the index to INDEX tablespace?
Thank you
Ablakios
Type:
alter index index_name rebuild tablespace new_tablespacename
Thank you for the prompt response.
Cheers