ORA-01495: specified chain row table not found
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Joel.Patterson@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 31 Oct 2008 13:13:00 -0400
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
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: ORA-01495: specified chain row table not found
- From: Mark W. Farnham
- References:
- RE: Chained vs. migrated rows - Any easy way to tell the difference?
- From: Joel . Patterson
Other related posts:
- » ORA-01495: specified chain row table not found
- » RE: ORA-01495: specified chain row table not found
- » RE: ORA-01495: specified chain row table not found
- RE: ORA-01495: specified chain row table not found
- From: Mark W. Farnham
- RE: Chained vs. migrated rows - Any easy way to tell the difference?
- From: Joel . Patterson