Oracle | DMP

Oracle DMP_SYS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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.