Import DataPump Errors ORA-39083 ORA-20000 Show That WMSYS Does Not Exist

(Doc ID 754948.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 07-May-2013***

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.w
m$_check_install return boolean is begin return true ; end;' ; end ; begi
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms