Oracle DMP_SYS
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 CURRENT_USER
Dependencies
ALL_ALL_TABLES DBMS_PREDICTIVE_ANALYTICS MODELATT$
DBMS_ASSERT DBMS_STANDARD OBJ$
DBMS_DATA_MINING DBMS_SYSTEM ODM_MODEL_UTIL
DBMS_DATA_MINING_INTERNAL DBMS_SYS_ERROR ORA_MINING_NUMBER_NT
DBMS_DATA_MINING_TRANSFORM DMP_SEC ORA_MINING_VARCHAR2_NT
DBMS_DM_MODEL_IMP DMUTIL_LIB PLITBLM
DBMS_DM_UTIL DM_QGEN USER$
DBMS_LOCK DUAL USER_TABLES
DBMS_OUTPUT MODEL$  
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtdmsu.plb
Subprograms
 
ADD_SETTING
Undocumented dmp_sys.add_setting(
settings   IN OUT sys.odm_model_util.model_set_tab,
name       IN     VARCHAR2,
value      IN     VARCHAR2,
properties IN     NUMBER,
dupsok     IN     BOOLEAN,
overwr     IN     BOOLEAN,
nullok     IN     BOOLEAN);
TBD
 
CALCULATE_MODEL_SIZE
Undocumented dmp_sys.calculate_model_size(model IN sys.odm_model_util.model_rec) RETURN NUMBER;
TBD
 
CREATE_MODEL_TABLES_LIST
Undocumented dmp_sys.create_model_tables_llist(
model_name IN VARCHAR2,
algorithm  IN VARCHAR2)
RETURN sys.odm_model_util.model_tab_tab;
TBD
 
CREATE_NEW_MODEL_TABLE_NAME
Undocumented dmp_sys.create_new_model_table_name(
model_name  IN VARCHAR2,
table_index IN CHAR)
RETURN VARCHAR2;
TBD
 
CREATE_NEW_TEMP_MODEL_NAME
Undocumented dmp_sys.create_new_temp_model_name RETURN VARCHAR2;
SELECT dmp_sys.create_new_temp_model_name
FROM dual;

CREATE_NEW_TEMP_MODEL_NAME
---------------------------
DM$TMOD1796108769
 
CREATE_NEW_TEMP_TABLE_NAME
Undocumented

Overload 1
dmp_sys.create_new_temp_table_name(prefix IN VARCHAR2)
RETURN VARCHAR2;
TBD
Overload 2 dmp_sys.create_new_temp_table_name(model IN OUT sys.odm_model_util.model_rec)
RETURN VARCHAR2;
TBD
 
DOWNGRADE_MODELS
Undocumented dmp_sys.downgrade_models(from_version IN VARCHAR2);
TBD
 
GENERATE_HASH_V
Undocumented dmp_sys.generate_hash_v(p IN VARCHAR2) RETURN VARCHAR2;
TBD
 
LOCK_MODEL
Undocumented dmp_sys.lock_model(
model_name IN VARCHAR2,
owner_name IN VARCHAR2,
lockmode   IN NUMBER);
TBD
 
PERSIST_MODEL
Undocumented dmp_sys.persis_model(
model      IN OUT sys.odm_model_util.model_rec,
attributes IN     sys.odm_model_util.model_att_list);
TBD
 
RELEASE_MODEL
Undocumented dmp_sys.release_model(
model_name IN VARCHAR2,
owner_name IN VARCHAR2);
exec dmp_sys.release_model('UWMODEL', 'C##UWCLASS');

PL/SQL procedure successfully completed.
 
UPGRADE_MODELS
Undocumented dmp_sys.upgrade_models(to_version IN VARCHAR2);
TBD
 
VERIFY_TABLE_EXISTENCE
Returns ORA-00942 if the table does not exist, else completes successfully dmp_sys.verify_table_existence(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2);
exec dmp_sys.verify_table_existence('C##UWCLASS', 'SERVERS');

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_DM_EXP_INTERNAL
DBMS_DM_MODEL_EXP
DBMS_DM_MODEL_IMP
DBMS_DM_UTIL
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