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
D ata M ining P redictive
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
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.