RE: ORA-01495: specified chain row table not found

From: <oracle-l-bounce_at_freelists.org>
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-l

Received on Fri Oct 31 2008 - 13:58:23 CDT