데이터베이스 질문과 답변
by hyphen [2012.01.31 17:24:00]
C:\hn_meta>impdp system/eyeqmc REMAP_SCHEMA=HN_META:HN_META REMAP_TABLESPACE=TS_
HN_META:HN_META directory=expdpdir dumpfile=DBHAN_HN_META_VER10.1.0_0130.DMP job
_name=hn_meta_imp_0131_2 logfile=hn_meta_0131_2.log table_exists_action=replace
Import: Release 11.2.0.1.0 - Production on 화 1월 31 17:16:04 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
접속 대상: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Productio
n
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: 내부 오류
ORA-39065: DISPATCH에 예상치 않은 마스터 프로세스 예외 사항 발생
ORA-00600: 내부 오류 코드, 인수: [kokle_lob2lob13:input mismatch], [1], [], [],
[], [], [], [], [], [], [], []
ORA-39097: 데이터 펌프 작업에서 예상치 않은 오류 -600 발생
C:\hn_meta>
에러메세지와 위와 같이 나는데.. 원인이 뭔지 몰라서 하루종일 헤매고 있네요 ㅠㅠ..
error 는 오라클 캐릭터셋 바꾸고 나서 발생을 한것 같긴한데.. 정확한 원인은 모르겠습니다.
Cause
Bug 6414719 closed as not a bug but a character set issue
Result of running this query:
select distinct(nls_charset_name(charsetid)) CHARACTERSET,
decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKNOWN'),
9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKNOWN'),
96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKNOWN'),
8, decode(charsetform, 1, 'LONG', 'UNKNOWN'),
112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKNOWN')) TYPES_USED_IN
from sys.col$ where charsetform in (1,2) and type# in (1, 8, 9, 96, 112)
order by CHARACTERSET, TYPES_USED_IN;
Returns these results:
AL16UTF16 NVARCHAR2
AR8MSWIN1256 CHAR
AR8MSWIN1256 CLOB
AR8MSWIN1256 VARCHAR2
UTF8 NCHAR
UTF8 NCLOB
UTF8 NVARCHAR2
WE8MSWIN1252 CHAR
WE8MSWIN1252 CLOB
WE8MSWIN1252 LONG
WE8MSWIN1252 VARCHAR2
Notice the multiple character sets used in the database; there should only be up to two character sets in the database.
Solution
Refer to Document 286964.1 to fix the character set issues that exist in the database. As this note was written for earlier versions, all of the steps to solution may not apply.
) 버튼을 클릭하여 작성 하시면 됩니다.