IMP-00017 ORA-20000 Importing older version of OWM into a higher version (Doc ID 743097.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Workspace Manager - Version to [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Jun-2015***


When exporting from an Oracle Database with Oracle Workspace Manager  (OWM) version installed and attempting to import into an Oracle Database with a different version of OWM,, the user will run into the following error:

. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 20000:
"declare ver varchar2(100) ; dummy integer; compile_exception EXCEPTION; PRA"
"GMA EXCEPTION_INIT(compile_exception, -06550); invalid_table EXCEPTION; PRA"
"GMA EXCEPTION_INIT(invalid_table, -00942); procedure createErrorProc is beg"
"in execute immediate 'create or replace function system.wm$_check_install r"
"eturn boolean is begin return true ; end;' ; end ; begin select 1 into dumm"
"y from dual where exists (select 1 from all_synonyms where owner = 'PUBLIC'"
" and synonym_name = 'DBMS_WM'); select 1 into dummy from dual where exists "
"(select 1 from all_users where username = 'WMSYS') ; execute immediate 'sel"
"ect value from wmsys.wm$env_vars where name=''OWM_VERSION''' into ver ; if "
"(ver not in ('', '', '')) then raise_applicati"
"on_error(-20000, 'Incompatible version of Workspace Manager Installed'); en"
"d if ; execute immediate 'declare cnt integer ; begin select count(*) into "
"cnt from (select workspace from wmsys.wm$version_hierarchy_table where vers"
"ion!=0 union all select table_name from wmsys.wm$versioned_tables) ; if (cn"
"t>0) then raise_application_error(-20189, ''workspaces, savepoints and vers"
"ioned tables'' || '' cannot be present on the IMPORT platform''); end if; e"
"nd;'; execute immediate 'create or replace function system.wm$_check_instal"
"l return boolean is begin return false ; end;' ; exception when no_data_fou"
"nd then createErrorProc ; raise_application_error(-20000, 'Workspace Manage"
"r Not Installed'); when compile_exception then createErrorProc ; raise_appl"
"ication_error(-20000, 'Workspace Manager Not Properly Installed'); when inv"
"alid_table then createErrorProc ; raise_application_error(-20000, 'Workspac"
"e Manager Not Properly Installed'); when others then createErrorProc ; rais"
"e; end;


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