ORA-600 [6947]/ORA-600 [kdsgrp1] 处理

ORA-600 [6947]/ORA-600 [kdsgrp1] 处理

ORA-600 [6947]/ORA-600 [kdsgrp1] 处理

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> SELECT tablespace_name, segment_type, owner, segment_name 
  2      FROM dba_extents 
  3      WHERE file_id = 3 
  4      and 22950 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME                SEGMENT_TYPE      OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSAUX                        TABLE              SYSMAN
MGMT_LICENSES

SQL> c/22950/37685
  4*    and 37685 between block_id AND block_id + blocks - 1
SQL> r
  1  SELECT tablespace_name, segment_type, owner, segment_name
  2      FROM dba_extents
  3      WHERE file_id = 3
  4*    and 37685 between block_id AND block_id + blocks - 1

TABLESPACE_NAME                SEGMENT_TYPE      OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSAUX                        TABLE              SYSMAN
SYS_IOT_OVER_49869

SQL> select table_name, iot_name from all_tables where table_name like '%IOT%';

TABLE_NAME                    IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_4478              RULE_SET_PR$
SYS_IOT_OVER_4484              RULE_SET_IOT$
SYS_IOT_OVER_4488              RULE_SET_ROP$
SYS_IOT_OVER_5082              AQ$_SCHEDULER$_JOBQTAB_G
SYS_IOT_OVER_5168              AQ$_SCHEDULER$_EVENT_QTAB_G
SYS_IOT_OVER_7157              AQ$_KUPC$DATAPUMP_QUETAB_G
SYS_IOT_OVER_8689              AQ$_AQ$_MEM_MC_G
SYS_IOT_OVER_8799              AQ$_ALERT_QT_G
SYS_IOT_OVER_9692              RECENT_RESOURCE_INCARNATIONS$
SYS_IOT_OVER_10099            AQ$_WM$EVENT_QUEUE_TABLE_G
SYS_IOT_OVER_35428            AQ$_SYS$SERVICE_METRICS_TAB_G

TABLE_NAME                    IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_40409            EXF$IDXSECOBJ
SYS_IOT_OVER_40883            DR$SQE
SYS_IOT_OVER_40928            DR$PARALLEL
SYS_IOT_OVER_42445            RLM$ERRCODE
SYS_IOT_OVER_42452            RLM$RULESET
SYS_IOT_OVER_42459            RLM$PRIMEVTTYPEMAP
SYS_IOT_OVER_42462            RLM$EQUALSPEC
SYS_IOT_OVER_42481            RLM$JOBQUEUE
SYS_IOT_OVER_42484            RLM4J$EVTSTRUCTS
SYS_IOT_OVER_42487            RLM4J$RULESET
SYS_IOT_OVER_42490            RLM4J$ATTRALIASES

TABLE_NAME                    IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_49766            AQ$_MGMT_NOTIFY_QTABLE_G
SYS_IOT_OVER_49869            MGMT_METRICS_RAW
SYS_IOT_OVER_49872            MGMT_CURRENT_METRICS
SYS_IOT_OVER_52389            ACTION_TABLE
SYS_IOT_OVER_52394            LINEITEM_TABLE
SYS_IOT_OVER_52776            AQ$_KUPC$DATAPUMP_QUETAB_D
RULE_SET_IOT$
SYS_IOT_OVER_51984            AQ$_STREAMS_QUEUE_TABLE_G
SYS_IOT_OVER_51967            AQ$_ORDERS_QUEUETABLE_G

31 rows selected.

SQL> create table SYSMAN.MGMT_METRICS_RAW_COPY
  2  as select * from SYSMAN.MGMT_METRICS_RAW;