Oracle ORA-600 [12406]

Posted by PDSERVICE on Nov 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

You are here

Oracle ORA-600 [12406]

Oracle ORA-600 [12406]