oracle 11gimpdp导入数据报错ora-39083和ora-00600啥情况呢？

Question

CREATE TABLE "BIDPRO"."SGCC_GUIDELINE_TYPE" ("ID" VARCHAR2(40 BYTE) NOT NULL ENABLE, "GUIDELINE_CODE" VARCHAR2(8 BYTE), "GUIDELIEN_NAME" VARCHAR2(50 BYTE), "IS_DEL" NUMBER(1,0), "UPDATE_TIME" TIMESTAMP (6), "CREATE_TIME" TIMESTAMP (6), "USER_ID" VARCHAR2(100 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRA
ORA-39083: 对象类型 TABLE:"BIDPRO"."SGCC_GUIDELINE_VALUE" 创建失败, 出现错误:
ORA-00600: 内部错误代码, 参数: [ktssinseg3], [5], [22263554], [], [], [], [], [], [], [], [], []
失败的 sql 为:
CREATE TABLE "BIDPRO"."SGCC_GUIDELINE_VALUE" ("ID" VARCHAR2(40 BYTE) NOT NULL ENABLE, "GUIDELINE_TYPE_CODE" VARCHAR2(8 BYTE), "GUIDELINE_VALUE_TYPE" VARCHAR2(1 BYTE), "GUIDELINE_VALUE" NUMBER, "GUIDELINE_VALUE1" NUMBER, "IS_DEL" NUMBER(1,0), "UPDATE_TIME" TIMESTAMP (6), "CREATE_TIME" TIMESTAMP (6), "GUIDELINE_CODE" VAR
ORA-39083: 对象类型 TABLE:"BIDPRO"."SGCC_IDENTIFY_CERT" 创建失败, 出现错误:
ORA-00600: 内部错误代码, 参数: [ktssinseg3], [5], [22263554], [], [], [], [], [], [], [], [], []

Answer 1

SYMPTOMS
Running a TTS import with Datapump the following error is raised:

ORA-00600: internal error code, arguments: [ktssinseg3], [7], [93463067]

in DW process.

In the related trace file we can see the failing command is a DDL , for example:

CREATE UNIQUE INDEX "REP_ADMIN"."RYOT_SPRO_ID_PK" on "REP_ADMIN"."REP_YIELD_OPER_TMP"("RYOT_SPRO_ID")PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(SEG_FILE 22 SEG_BLOCK 1188379 OBJNO_REUSE 720739 INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "REP_ADMIN" NOPARALLEL

CAUSE
The internal error is being caused because the object target tablespace already exist in the target DB (REP_ADMIN in above example), and the block used in the create command is already being used by other object.
Executing the following query in the target DB:
SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = <file#>
and <block#> between block_id AND block_id + blocks - 1;
where file# is the first argument in the internal error ([7] in the above reference) and block# is the second argument in the internal error ([93463067] above), returns the existing object using the requested block.

SOLUTION
To prevent this internal error you would need to make sure no objects are manually created between the import of both tablespaces or to manually create the missing constraints/indexes after the import is completed.

需要具体的TRACE进一步分析该问题

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

Answer 2

ding