Action
SQL>
ANALYZE TABLE HR.EMPLOYEES LIST CHAINED ROWS INTO CHAINED_ROWS;
Error
ORA-01495: specified chain row table not found
Solution
SQL>
CREATE TABLE HR.CHAINED_ROWS
(
OWNER_NAME VARCHAR2 (30),
TABLE_NAME VARCHAR2 (30),
CLUSTER_NAME VARCHAR2 (30),
PARTITION_NAME VARCHAR2 (30),
SUBPARTITION_NAME VARCHAR2 (30),
HEAD_ROWID ROWID,
ANALYZE_TIMESTAMP DATE
);
