This error occurs just for 2 tables out of 269 in the same schema. The two tables both contain three columns. The data_types for all columns in each table are CHAR (of varying small lengths 5 to 30). One table contains 0 rows, and the other over 100000. Metalink has nothing (explaining this), and Google is producing nothing. The privileges are the same for every table. The schema owns all the tables including the chained_row table. Error: ORA 1495 Text: specified chain row table not found ------------------------------------------------------------------------ ------- Cause: The specified table does not exist, or the user does not have the proper privileges to access it. Action: Specify an existing table or obtain the privileges to access the desired table. EXAMPLE: PEGADMIN @ pegaccp> ANALYZE TABLE LOC_SUPPLIED_DATA LIST CHAINED ROWS; ANALYZE TABLE LOC_SUPPLIED_DATA LIST CHAINED ROWS * ERROR at line 1: ORA-01495: specified chain row table not found ------------- On a side note if anyone would care to comment is that dba_tables show ssignificantly different counts than analyze table results select table_name, chain_cnt from dba_tables where owner = 'PEGADMIN' and chain_cnt <> 0 order by table_name; TABLE_NAME CHAIN_CNT ------------------------------ ---------- CHASSIS 71 CONTRACT 229 CONTRACT_REF_NUM 155 INTERFACE_ERROR 880 MOVE 7936 RAIL_MOVE 568 STOP 10861 TRAILER 5121 CHAINED_ROWS_table -- count by table. ----------------------------------------- CHASSIS 1635 CONTRACT 4310 CONTRACT_REF_NUM 1110 GENSET 115 INTERFACE_ERROR 4284 LOCATION_CONTACT 14 LOCATION_NICKNAME 6 MOVE 105270 RAIL_MOVE 4370 STOP 160862 TRAILER 5673 VS_MOVE 105 Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 -- //www.freelists.org/webpage/oracle-l