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

Thanks, 

That looks like the track I needed. I'll look into it.



Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904  727-2546

-----Original Message-----
From: Mark W. Farnham [mailto:mwf@xxxxxxxx] 
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: Friday, October 31, 2008 1:13 PM
To: Joel.Patterson@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx
x72546
904  727-2546

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Other related posts: