Oracle | OWM_MP

Oracle OWM_MP_PKG Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented

AUTHID CURRENT_USER

Dependencies

DBMS_LOB	OWM_DDL_PKG	WM$MP_GRAPH_WORKSPACES_TABLE
DUAL	OWM_DYNSQL_ACCESS	WM$MP_PARENT_WORKSPACES_TABLE
LT	PLITBLM	WM$NESTED_COLUMNS_TABLE
LTADM	WM$CONSTRAINTS_TABLE	WM$RIC_TABLE
LTI	WM$MODIFIED_TABLES	WM$VERSIONED_TABLES
LTPRIV	WM$MP_GRAPH_NEW_VERSIONS	WM$VERSION_TABLE
LTRIC	WM$MP_GRAPH_OTHER_VERSIONS	WM$VERSION_VIEW
LTUTIL	WM$MP_GRAPH_REMAINING_VERSIONS	WM$WORKSPACES_TABLE
LT_CTX_PKG	WM$MP_GRAPH_REMOVED_VERSIONS	WM_ERROR
OWM_ASSERT_PKG

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmmps.plb

Subprograms

ADDASPARENTWORKSPACE	GETGRAPHNODES	REMOVEASPARENTWORKSPACE
CREATEIMPLICITSPINGRAPH	GETNCA	SETMPPARAMETER
EXISTSMPWORKSPACE	ISMPWORKSPACE

ADDASPARENTWORKSPACE

Undocumented owm_mp_pkg.addAsParentWorkspace( workspace IN VARCHAR2, parent_workspace IN VARCHAR2);

TBD

CREATEIMPLICITSPINGRAPH

Undocumented owm_mp_pkg.createImplicitSpinGraph( leaf_workspace IN VARCHAR2, description IN VARCHAR2)

TBD

EXISTSMPWORKSPACE

Retrns TRUE if the MP Workspace exists, else FALSE

Protected by an Accessible By clause owm_mp_pkg.existsMPWorkspace RETURN BOOLEAN;

BEGIN

        IF wmsys.owm_mp_pkg.existsMPWorkspace THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      PLS-00904: insufficient privilege to access object OWM_MP_PKG

GETGRAPHNODES

Undocumented

Overload 1 owm_mp_pkg.getGraphNodes( leaf_workspace IN VARCHAR2, parent_workspace_var IN VARCHAR2, node_types IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab_bin;

TBD

Undocumented

Overload 2 owm_mp_pkg.getGraphNodes( leaf_workspace IN VARCHAR2, node_types IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab_bin;

TBD

GETNCA

Undocumented owm_mp_pkg.getNCA( workspace1 IN VARCHAR2, workspace2 IN VARCHAR2) RETURN VARCHAR2;

TBD

ISMPWORKSPACE

Undocumented owm_mp_pkg.isMPWorkspace( mp_leaf_workspace_VAR IN VARCHAR2, parent_workspace_VAR IN VARCHAR2) RETURN BOOLEAN;

TBD

REMOVEASPARENTWORKSPACE

Remove the parent workspace for the indicated MP Leaf workspace owm_mp_pkg.removeAsParentWorkspace( mp_leaf_workspace IN VARCHAR2, parent_workspace IN VARCHAR2);

TBD

SETMPPARAMETER

Undocumented owm_mp_pkg.setMPParameter(new_value IN VARCHAR2);

TBD