RE: ORA-01495: specified chain row table not found
Date: Fri, 31 Oct 2008 14:58:23 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA01E305E1@JAXMSG01.crowley.com>
Thanks,
That looks like the track I needed. I'll look into it.
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
-----Original Message-----
From: Mark W. Farnham [mailto:mwf_at_rsiz.com]
Sent: Friday, October 31, 2008 2:12 PM
To: Patterson, Joel
Cc: 'ORACLE-L'
Subject: RE: ORA-01495: specified chain row table not found
Perhaps you might consider explicitly designating the destination table
and
use a separate destination table for each of the non-working source
tables.
I trust you've read the very fine manual regarding things you need to do with IOT source tables.
Regards,
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Joel.Patterson_at_crowley.com
Sent: Friday, October 31, 2008 1:13 PM
To: Joel.Patterson_at_crowley.com; oracle-l_at_freelists.org
Subject: ORA-01495: specified chain row table not found
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_at_crowley.com
x72546
904 727-2546
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 31 2008 - 13:58:23 CDT