Oracle OWM_MP_PKG
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID DEFINER
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
Source {ORACLE_HOME}/rdbms/admin/owmmps.plb
Subprograms
 
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;
/
 IF wmsys.owm_mp_pkg.existsMPWorkspace THEN
*
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00904: insufficient privilege to access object OWM_MP_PKG
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
 
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DML_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_VSCRIPT_PKG
OWM_VT_PKG
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx