咨询微信： dbservice1234 7 x 24 在线支持！

首页

下载 DBRECOVER

Oracle ORA-600 [12406]

Oracle ORA-600 [12406]

Posted by PDSERVICE on 11月 18, 2015 In
Format: ORA-600 [12406] [a] [b] [c] [d] [e]
 
VERSIONS:
 
versions 8.0 to 8.1
 
DESCRIPTION:
 
This exception is generated due to a bad internal rowid.
This error is signaled with the data object number of a long rowid
is invalid.
 
FUNCTIONALITY:
 
TABLE ROW SOURCE
 
IMPACT:
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.
 
Attempt to reproduce the problem.
 
Run the ANALYZE command on all tables and indexes involved and ensure
 
no errors.
 
For tables:
analyze table <tablename> validate structure cascade;
 
For index:
analyze index <indexname> validate structure;
 
 
11.2.0.2,
12.1.0.0
Fast split of LIST subpartition with COMPRESS KEY
index produces corrupt index
9563951 11.1.0.7.11, 11.2.0.2 Intermittent Wrong Results / Internal error with
nested loops and expressions
8501439 11.1.0.7.8, 11.2.0.1
OERI[kghfrh:ds] / [kghfrempty:ds] / [17147] ORA-
7445 [memcpy] with ANALYZE in a table with added
column
8316612 11.2.0.1 ORA-600 [12406] / wrong results from CONNECT BY
on fixed tables
4741394 10.2.0.3, 11.1.0.6 OERI [12406]/Wrong Results from CONNECT BY query
4528339 10.2.0.3, 11.1.0.6 OERI [12406] from CONNECT BY query with
subqueries
4951371 OERI [12406] from CONNECT BY using START WITH
3039404 9.2.0.5, 10.1.0.2 OERI[12406] using NOT CONTAINS with local
partitioned TEXT index
 
1668041 9.2.0.1 Incorrect LOB block data may be read when using
CACHE READS - many possible errors (eg: ORA-1555)
427458 7.3.3.5, 7.3.4.1, 8.0.3.0 OERI:12406 on SELECT with OR branch & SMJ to 1-
row-left tbl
 
 
Bug:2608394
ORA-600 [12406]
ALTER TABLE ... EXCHANGE PARTITION ... INCLUDING INDEXES command.
(base bug 1165523)
Should be reporting ORA-28665 table and partition must have same
compression attribute
Fixed: 9.0.1 and 10g