Oracle Database Discussions

Hello everyone, I recently met a base having a strange problem

A partitioned table that has a common index which constantly becomes unusable state.
I will rebuild but after a while starts again unusable.

My question is if I need some kind of index in particular to partitioned tables and so prevent them from being unusable state
Reading about this i found that various types of indixes viable, but really dont know which is correct for this case.

I'm leaving the details of the creation of the table, as it has many partitions and will not come here, but if I leave the logs I found the problem.

Greetings

Some indexes or index [sub] partitions of table unusable DATA_USAGE.FT_DATA_USAGE_DETAIL Have Been Marked

CREATE TABLE FT_DATA_USAGE_DETAIL
(
FILE_DATECODE VARCHAR2(20 BYTE),
FILE_NAME VARCHAR2(50 BYTE),
FILE_ID NUMBER,
RECORD_DATE DATE,
PREV_RECORD_DATE DATE,
RECORD_DATECODE VARCHAR2(8 BYTE),
PREV_RECORD_DATECODE VARCHAR2(8 BYTE),
RECORD_TYPE VARCHAR2(20 BYTE),
PREV_RECORD_TYPE VARCHAR2(20 BYTE),
CPE_MAC_ADDRESS VARCHAR2(50 BYTE),
SESSION_ID VARCHAR2(100 BYTE),
PREV_SESSION_ID VARCHAR2(100 BYTE),
SESSION_STATUS_ID VARCHAR2(20 BYTE),
BYTES_INPUT_VOLUME NUMBER,
BYTES_OUTPUT_VOLUME NUMBER,
PACKETS_INPUT_VOLUME NUMBER,
PACKETS_OUTPUT_VOLUME NUMBER,
GIGAWORDS_INPUT_VOLUME NUMBER,
GIGAWORDS_OUTPUT_VOLUME NUMBER,
SESSION_DURATION NUMBER,
BYTES_INPUT_PART_VOLUME NUMBER,
BYTES_OUTPUT_PART_VOLUME NUMBER,
PACKETS_INPUT_PART_VOLUME NUMBER,
PACKETS_OUTPUT_PART_VOLUME NUMBER,
GIGAWORDS_INPUT_PART_VOLUME NUMBER,
GIGAWORDS_OUTPUT_PART_VOLUME NUMBER,
SESSION_PART_DURATION NUMBER,
SERVICE_ID NUMBER,
SERVICE_STATUS_ID VARCHAR2(10 BYTE),
PROFILE_ID VARCHAR2(20 BYTE),
ACCOUNT_ID NUMBER,
ACCOUNT_STATUS_ID VARCHAR2(10 BYTE),
PRODUCT_ID NUMBER,
CUSTOMER_ID NUMBER,
BILL_CYCLE_ID NUMBER,
WIMAX_BS_ID VARCHAR2(50 BYTE),
FRAMED_IP_ADDRESS VARCHAR2(20 BYTE),
SUBSCRIPTION_ID VARCHAR2(50 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
PARTITION BY RANGE (FILE_DATECODE)
(
PARTITION P_20091217 VALUES LESS THAN ('20091218')
LOGGING
NOCOMPRESS
TABLESPACE USERS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
),
PARTITION P_20091218 VALUES LESS THAN ('20091219')
LOGGING
NOCOMPRESS
TABLESPACE USERS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
NOPARALLEL;