Index getting unusable in partitioned table
-- create a tablespace for data CREATE TABLESPACE TBS_PART_TEST DATAFILE 'TBS_PART_TEST01.DBF' SIZE 10M AUTOEXTEND OFF, 'TBS_PART_TEST02.DBF' SIZE 10M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; -- create a tablespace for index CREATE TABLESPACE TBS_PART_TEST_IND DATAFILE 'TBS_PART_TEST_IND01.DBF' SIZE 10M AUTOEXTEND OFF LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; -- creat a user to perform the activities CREATE USER PART IDENTIFIED BY VALUES '9725DA1D2FBD22FC' DEFAULT TABLESPACE TBS_PART_TEST TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 4 Roles for PART GRANT SELECT_CATALOG_ROLE TO PART; GRANT DBA TO PART; GRANT RESOURCE TO PART; GRANT CONNECT TO PART; ALTER USER PART DEFAULT ROLE ALL; -- 1 System Privilege for PART GRANT UNLIMITED TABLESPACE T...