Database Administration (MOSC)

MOSC Banner

How to change degree of partitioned index

edited Feb 26, 2015 10:01AM in Database Administration (MOSC) 7 commentsAnswered


Hi

alter index test_idx6 rebuild partition test1 tablespace BIG_INDEX parallel 4;

11:50:03 SQL>  SELECT INDEX_NAME, DEGREE FROM DBA_INDEXES WHERE INDEX_NAME='TEST_IDX6';

INDEX_NAME                     DEGREE
------------------------------ ----------------------------------------
TEST_IDX6                1

In dba_indexes, the degree of test_idx6 is still 1.

How can I change the partitioned index test_idx6 back to parallel 1?

Thanks,

Tracy

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center