Oracle | DMP

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 Data Mining Predictive Analytics Support Utilities

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	CREATE_NEW_TEMP_TABLE_NAME	PERSIST_MODEL
CALCULATE_MODEL_SIZE	DOWNGRADE_MODELS	RELEASE_MODEL
CREATE_MODEL_TABLES_LIST	GENERATE_HASH_V	UPGRADE_MODELS
CREATE_NEW_MODEL_TABLE_NAME	LOCK_MODEL	VERIFY_TABLE_EXISTENCE
CREATE_NEW_TEMP_MODEL_NAME

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.