update wmsys.wm$env_vars set value = '11.2.0.3.0' where name = 'OWM_VERSION';
commit;
create or replace function wmsys.get_expanded_nextvers wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
269 19d
pGwkFZjwr/4ajpli3MJGYw41Fgowg/AJ2SdqfC+KMQ8tB+ZWBkAbxux2kRK2mZExfTjaSczj
KWKJ34nPPwFs4ulr0G3bvMkXYIOI9/YrmTCI/59TNCJPSmqzQUDZOgswEtDH72OUYqDDi2yN
/Ra4gLKxynTBNhQn70T1jXtNXOpVmYoybSXgmlQuggoosuFe81+Q0fulgLvrM/5AdWerrVM0
4sUnE6P7tqv+Fsb6LvzVaJ/YUAFUOObevbfsNm/6Zlh/01S2B+zuQb0HpjTiEwjLr3aFdnpH
A0GyWZIrSmUYZrLHCDvbJiVdFzeMVwFlxsfoiHzko9zTu3OBFOuSMSiu9Z6n+ylDe3PR/J08
zn+KWEDiovOmfu6z6pDJu4ON/83qaEF68GCAuSL7Ql5P/A==

/
begin
  delete wmsys.wm$nextver_table
  where next_vers != '-1' and split=1 and
  exists (select 1
          from table(wmsys.get_expanded_nextvers(next_vers)) n
          where n.next_vers not in(select version from wmsys.wm$version_hierarchy_table v)) ;
end;
/
drop function wmsys.get_expanded_nextvers ;
create or replace view wmsys.wm$exp_map as
select *
from table(wmsys.lt_export_pkg.export_mapping_view_func()) ;
create table wmsys.wm$exp_map_tbl as (select * from wmsys.wm$exp_map where 1=2) ;
delete sys.impcalloutreg$ where tag='WMSYS';
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$EXP_MAP', 4, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$BATCH_COMPRESSIBLE_TABLES', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$CONSTRAINTS_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$CONS_COLUMNS', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$ENV_VARS', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$EVENTS_INFO', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$HINT_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$INSTEADOF_TRIGS_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$LOCKROWS_INFO', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$MODIFIED_TABLES', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$MP_GRAPH_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$MP_PARENT_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$NESTED_COLUMNS_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$NEXTVER_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$REMOVED_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RESOLVE_WORKSPACES_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RIC_LOCKING_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RIC_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$RIC_TRIGGERS_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$UDTRIG_DISPATCH_PROCS', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$UDTRIG_INFO', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$VERSION_HIERARCHY_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$VERSION_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$VT_ERRORS_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$WORKSPACES_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$WORKSPACE_PRIV_TABLE', 2, 'Workspace Manager') ;
insert into sys.impcalloutreg$ values('LT_EXPORT_PKG', 'WMSYS', 'WMSYS', 3, 1000, 0, 'WMSYS', 'WM$WORKSPACE_SAVEPOINTS_TABLE', 2, 'Workspace Manager') ;
commit ;