Import DataPump Errors ORA-39083 ORA-20000 Show That WMSYS Does Not Exist
(Doc ID 754948.1)
Last updated on AUGUST 02, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Using DataPump to export a 10.2.0.4 database and import to a new 10.2.0.4 database, the following errors occur:
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-20000: Workspace Manager Not Installed
Failing sql is:
BEGIN
declare ver varchar2(100) ; dummy integer; vdummy varchar2(30) ; compile_exception EXCEPTION;
PRAGMA EXCEPTION_INIT(compile_exception, -06550); invalid_
table EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_table, -00942); procedure createErrorProc is begin
execute immediate 'create or replace function system.wm$_check_install return boolean is begin return true ; end;'
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-20000: Workspace Manager Not Installed
ORA-20000: Workspace Manager Not Installed
Failing sql is:
BEGIN
declare ver varchar2(100) ; dummy integer; vdummy varchar2(30) ; compile_exception EXCEPTION;
PRAGMA EXCEPTION_INIT(compile_exception, -06550); invalid_
table EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_table, -00942); procedure createErrorProc is begin
execute immediate 'create or replace function system.wm$_check_install return boolean is begin return true ; end;'
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-20000: Workspace Manager Not Installed
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |