-
Title
Error "ORA-00600: internal error code, arguments: [15570], [], [], [], [], [], [], []," when gene -
Description
Error "ORA-00600: internal error code, arguments: [15570], [], [], [], [], [], [], []," when generating script for a partitioned table
-
Cause
Oracle Bug 12368039 - ORA-600 [15570] with UNION ALL views with Parallel steps (Doc ID 12368039.8). when Toad runs the following query in the background:
Select INDEX_OWNER, INDEX_NAME, PARTITION_NAME, HIGH_VALUE, HIGH_VALUE_LENGTH, PARTITION_POSITION, STATUS,
TABLESPACE_NAME, LOGGING, nvl(INI_TRANS, -1) ini_trans, nvl(MAX_TRANS, -1) max_trans,
nvl(INITIAL_EXTENT, -1) initial_extent, nvl(NEXT_EXTENT, -1) next_extent,
nvl(MIN_EXTENT, -1) MIN_EXTENT, nvl(MAX_EXTENT, -1) MAX_EXTENT, nvl(PCT_INCREASE, -1) PCT_INCREASE, nvl(PCT_FREE, -1) PCT_FREE,
nvl(FREELISTS, -1) freelists, nvl(FREELIST_GROUPS, -1) freelist_groups, buffer_pool,
LAST_ANALYZED, nvl(NUM_ROWS, -1) NUM_ROWS
, SUBPARTITION_COUNT, COMPRESSION
,FLASH_CACHE, CELL_FLASH_CACHE
FROM SYS.DBA_IND_PARTITIONS
WHERE 1=1
and (index_owner, index_name) in (Select owner, index_name
from SYS.DBA_INDEXES
where table_owner = :own
and TABLE_NAME = :OneObjectName )
ORDER BY INDEX_NAME, PARTITION_POSITION -
Resolution
Not a Toad issue
Oracle bug fixed in Oracle patch 11.2.0.2. Please review the Oracle metalink article 12368039 for additional information.