반응형
구성환경
OS : CentOS 5
DB : Oracle 9i ( 9.2.0.8 )
문제
[oracle@host01:/home/oracle]$ exp oggmgr/oggmgr file=hr_20220519.dmp log=hr_20220519.log tables=hr.employees
Export: Release 9.2.0.8.0 - Production on Fri May 20 11:13:23 2022
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
Export done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
Current user changed to HR
. . exporting table EMPLOYEES 107 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.해당 DB에서 export 실행 시 위와 같은 EXP-00091: Exporting questionable statistics. 메시지가 나오는 문제
이 문제는 export할 때 데이터의 통계정보도 같이 export하려고 할때 발생하는 문제로 통계정보를 제외하고 나머지만 export 하기 위해서는 statistics=none 옵션을 추가하여야 한다.
조치
[oracle@host01:/home/oracle]$ exp oggmgr/oggmgr file=hr_20220519.dmp log=hr_20220519.log tables=hr.employees statistics=none
Export: Release 9.2.0.8.0 - Production on Fri May 20 11:27:13 2022
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
Export done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
Current user changed to HR
. . exporting table EMPLOYEES 107 rows exported
Export terminated successfully without warnings.
[추가]
서버의 character set 또는 NCHARSET 이 클라이언트의 문자셋이 일치하지 않아 발생하는 문제일 수 있음
[참고]
http://www.dba-oracle.com/t_exp_00091_exporting_questionable_statistics.htm
반응형
'Oracle' 카테고리의 다른 글
| [Oracle 19c] CentOS 7 에 Oracle 19.3.0 설치 가이드 (0) | 2022.06.17 |
|---|---|
| [CentOS 5] Oracle 9i 설치 및 패치 (9.2.0.4에서 9.2.0.8로 Patch) (0) | 2022.05.24 |
| [OGG] Oracle Golden Gate - 9i single to 11g rac (0) | 2022.05.17 |
| CentOS 7 에 Oracle 11.2.0.4 설치 가이드 (0) | 2021.12.24 |
| ORACLE 11.2.0.1에서 11.2.0.4 로 업그레이드 (11g to 11.2.0.4 Upgrade) (0) | 2021.12.22 |
