Problém

Export log datové pumpy (expdp) obsahuje následující chyby
expdp system/heslo@orcl full=Y directory=TEST_DIR dumpfile=orcl.dmp logfile=orcl.log

Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
>>> 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

Export log (exp) obsahuje následující chyby
exp SYSTEM/heslo@orcl file=d:\export\full3.dmp log=d:\export\exp3.log full=yes consistent=yes statistics=none

EXP-00008: ORACLE error 29280 encountered
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "SYS.DBMS_AW_EXP", line 97
ORA-06512: at "SYS.DBMS_AW_EXP", line 1220
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_AW_EXP.instance_extended_info_exp for object 77414

Řešení

MOS: How To Find Out If OLAP Is Being Used (Doc ID 739032.1)
SQL> select VALUE
 2 from v$OPTION
 3 where PARAMETER = 'OLAP';

VALUE
----------------------------------------------------------------
FALSE

SQL> select name "FEATURE", first_usage_date "FROM", last_usage_date "TO"
 2 from DBA_FEATURE_USAGE_STATISTICS
 3 where name like '%OLAP%'
 4 /

FEATURE FROM TO
---------------------------------------------------------------- ---------
OLAP - Analytic Workspaces
OLAP - Cubes

MOS: How to Remove OLAP from the Standard Edition Database? (Doc ID 1362752.1)

SQL> drop user OLAPSYS cascade;
User dropped.

SQL> @c:\oracle\product\11.2.0\dbhome_1\rdbms\admin\utlrp
SQL> SELECT owner,
 2 object_type,
 3 object_name,
 4 status
 5 FROM dba_objects
 6 WHERE status = 'INVALID'
 7 ORDER BY owner, object_type, object_name;

OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME STATUS
------------------------------ -------
SYS PACKAGE BODY
CWM2_OLAP_INSTALLER INVALID

MOS: Remove Invalid OLAP Objects From SYS And OLAPSYS Schemas (Doc ID 565773.1)

SQL> drop package sys.CWM2_OLAP_INSTALLER;
Package dropped.

SQL> SELECT owner,
 2 object_type,
 3 object_name,
 4 status
 5 FROM dba_objects
 6 WHERE status = 'INVALID'
 7 ORDER BY owner, object_type, object_name;
no rows selected

SQL> select * from sys.exppkgact$ where package = 'DBMS_AW_EXP' and
 2 schema= 'SYS';
PACKAGE SCHEMA CLASS LEVEL#
------------------------------ ------------------------------ ----------
DBMS_AW_EXP SYS 2 1000
DBMS_AW_EXP SYS 4 1000
DBMS_AW_EXP SYS 6 1000

SQL> delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'
 2 and schema= 'SYS';
3 rows deleted.

SQL> commit;
Commit complete.

MOS: DataPump Export (EXPDP) Errors ORA-39127 SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP ORA-44002 After Upgrade (Doc ID 1353491.1)

SQL> select * FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP' AND SCHEMA= 'SYS';
PACKAGE SCHEMA CLASS LEVEL#
------------------------------ ------------------------------ ----------
DBMS_CUBE_EXP SYS 2 1050
DBMS_CUBE_EXP SYS 4 1050
DBMS_CUBE_EXP SYS 6 1050

SQL> select PACKAGE, SCHEMA, class from exppkgact$ where (schema, package) not in (select owner, ob
ect_name from dba_objects where object_type='PACKAGE');
no rows selected

SQL> delete from exppkgact$ where package = 'DBMS_CUBE_EXP' and schema = 'SYS';
3 rows deleted.

SQL> commit;
Commit complete.

SQL> select * FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP' AND SCHEMA= 'SYS';
no rows selected

Komentáře