Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
Symptoms
Expdp on Oracle Standard Edition / Standard Edition 1 produces below warnings
DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
Export: Release 11.2.0.4.0 - Production on Fri Jan 8 04:38:29 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production Starting "SYSTEM"."FULL_MASICCA": system/******** DIRECTORY=PUMP_DIR SCHEMAS=MAGI*** CONTENT=ALL DUMPFILE=FULL_MASI***.dmp LOGFILE=FULL_MASI***.log JOB_NAME=FULL_MASI*** Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 238.5 GB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE >>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY >>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
Cause
The issue was explained in
Bug 17718899 - EXPDP ON STANDARD EDITION ONE SHOWS MESSAGES "OLAP NOT ENABLED"
closed with status 'Not a Bug' with below comment:
OLAP is not available in Standard Edition One (SE1) or Standard Edition (SE) as per the Database Licensing Information document,
it is only available in Enterprise Edition (EE).
This message is intentionally output for DATAPUMP and coded as such in 11.2.0.4 and higher Standard Edition One (SE1) or Standard Edition (SE).
From the Datapump perspective these are warnings and it is safe to ignore them.
The same symptoms can be encountered with the Oracle Enterprise Edition when OLAP is not installed.
Solution
The OLAP related warnings can be safely ignored for DapaPump usage.
출처 : support.oracle.com (문서 ID 1638799.1)
댓글 0
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 9 | DB 컨트롤 파일 추가하기 | 명품관 | 2023.03.27 | 965 |
| 8 | data pump 모니터링 | 명품관 | 2023.01.31 | 984 |
| 7 | Rman 복구 중 Netbackup 이 연결이 안되는 에러 [1] | Talros | 2022.11.24 | 119 |
| 6 | 12C RAC, OS Fault 로 다운된 1번 Node 재구성 | Talros | 2020.08.28 | 1095 |
| 5 |
alter database begin backup 사용을 권해 드립니다.
[1]  | 우뽕 | 2020.01.22 | 14316 |
| 4 | Rman 을 이용해 ASM 에 컨트롤 파일 복구 하기 [1] | Talros | 2019.07.16 | 2878 |
| 3 | Data Pump Query 파라미터 사용법 [1] | Talros | 2016.01.28 | 4493 |
| » | Data pump 사용시 Warnings Like DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled | Talros | 2016.01.08 | 1965 |
| 1 | 비정상적인 복구를 수행하게 되는 경우(Redo log 유실, Archive log 파일 부재, Resetlog open 에러) | 명품관 | 2015.12.22 | 6788 |