SQL>
OWNER INDEX_NAME TABLESPACE_NAME
------------------------------ ------------------------------ ---------------
SYS TEST_SC OLD_INDEX
I want to move TEST_SC which is wrongly created in OLD_INDEX tablespace. User want to move to NEW_INDEX tablespace,
SQL>alter index <INDEX_NAME> rebuild tablespace <NEW TABLESPACE> PARALLEL NOLOGGING;
SQL>alter index TEST_SC rebuild tablespace NEW_INDEX PARALLEL;
SQL>
OWNER INDEX_NAME TABLESPACE_NAME
------------------------------ ------------------------------ ---------------
SYS TEST_SC NEW_INDEX
User carefully with NOLOGGING option if you have DR.
If you are moving large index, check in V$SESSION_LONGOPS to see how much it progressed and how long it will take (approx).
No comments:
Post a Comment