'Oracle ORA-04063: table "TABLE" has errors

I Create a table with UDT type as a column , after some time i needed one more column to add the type, i altered the type using

alter type type_cust_instatus add attribute (sub_status_to varchar2(20)) invalidate
alter type type_cust_instatus compile


After that the table becomes invalid and tried to make the column unused and dropped the the type also and recreaded once again as per before modification.

now in the table defination there is no type fro the column and showing as blank
how to delete the column or recompile

CREATE TABLE KAMSIT.CUSTOMER_TRANSACTION_DATA
(
  MSISDN                VARCHAR2(13 BYTE),
  IMSI                  VARCHAR2(15 BYTE),
  CONNECTION_TYPE       NUMBER,
  MSTYPE                VARCHAR2(6 BYTE),
  SUBSCR_NO             VARCHAR2(10 BYTE),
  ACCOUNT_NO            VARCHAR2(10 BYTE),
  ALUIN_ACTIVE_DATE     DATE,
  FIRST_CALL_MADE_TIME  DATE,
  ACTIVE_DATE           DATE,
  INACTIVE_DATE         DATE,
  BILLING_IMSI          VARCHAR2(15 BYTE),
  CURRENT_STATUS        VARCHAR2(1 BYTE)        DEFAULT 'C',
  ALUIN_IMSI            VARCHAR2(15 BYTE),
  ALUIN_SUB_STATUS      VARCHAR2(50 BYTE),
  INSERT_DATE           DATE                    DEFAULT sysdate,
  TRANSACTION_TYPE      KAMSIT.CUSTOMER_TRANSACTION_TYPE,
  TRANSACTION_IMSI      KAMSIT.CUST_IMSI_CHANGE,
  ALUIN_STATUS          VARCHAR2(1 BYTE)        DEFAULT 'C',
  IMEI                  VARCHAR2(20 BYTE),
  TRANSACTION_INSTATUS
)
NESTED TABLE TRANSACTION_TYPE STORE AS TBL_CUSTOMER_TRANSACTIONS,
NESTED TABLE TRANSACTION_IMSI STORE AS TBL_TRANSACTION_IMSI

how to drop the column or set unused or rebuild the table



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source