Oracle | DBMS_DM_MODEL

Oracle DBMS_DM_MODEL_IMP 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 utility supporting model creation and persistence

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DM_MODEL_SETTING	ORA_MINING_NUMBER_NT
DBMS_DATAPUMP	DM_MODEL_SETTINGS	ORA_MINING_TABLES_NT
DBMS_DM_UTIL	DM_MODEL_SIGNATURE	ORA_MINING_TABLE_TYPE
DBMS_SYSTEM	DM_MODEL_SIGNATURE_ATTRIBUTE	ORA_MINING_VARCHAR2_NT
DMP_SEC	KU$_STATUS	PLITBLM
DMP_SYS	ODM_MODEL_UTIL

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtdmsu.plb creates the package

{ORACLE_HOME}/rdbms/admin/dmeidmsys.sql is not used and should be ignored.

Subprograms

Add a table to a data mining model dbms_dm_model_imp.add_table( model_name IN VARCHAR2, table_type IN VARCHAR2, table_name IN VARCHAR2);

TBD

CREATE_MODEL

Create a data mining model dbms_dm_model_imp.create_model( model_name IN VARCHAR2, mining_function IN VARCHAR2, algorithm IN VARCHAR2, target IN VARCHAR2, duration IN NUMBER, model_size IN NUMBER);

TBD

PERSIST_MODEL

Persist a data mining model dbms_dm_model_imp.persist_model( model_name IN VARCHAR2 mining_function IN VARCHAR2 algorithm IN VARCHAR2 build_duration IN NUMBER model_size IN NUMBER version IN NUMBER comment IN VARCHAR2 model_tables IN sys.ora_mining_tables_nt, model_settings IN sys.dm_model_settings, set_prop IN sys.ora_mining_number_nt, model_attr IN sys.dm_model_signature, attr_dtype IN sys.ora_mining_varchar2_nt, attr_len IN sys.ora_mining_number_nt, attr_prec IN sys.ora_mining_number_nt, attr_scal IN sys.ora_mining_number_nt, attr_prop IN sys.ora_mining_number_nt, attr_dtypn IN sys.ora_mining_number_nt, model_pseq IN NUMBER model_pco IN NUMBER model_prop IN NUMBER, model_xfrm_attr IN sys.ora_mining_varchar2_nt, model_xfrm_subn IN sys.ora_mining_varchar2_nt, model_xfrm_prop IN sys.ora_mining_number_nt, model_xfrm_idty IN sys.ora_mining_number_nt, model_xfrm_ibfl IN sys.ora_mining_number_nt, model_xfrm_dtyp IN sys.ora_mining_number_nt, model_xfrm_bufl IN sys.ora_mining_number_nt, model_xfrm_attrspec IN sys.ora_mining_varchar2_nt, exp_l IN sys.ora_mining_number_nt, r_exp_l IN sys.ora_mining_number_nt, model_xfm IN CLOB, part_a_part# IN sys.ora_mining_number_nt, part_a_subname IN sys.ora_mining_number_nt, part_a_name IN sys.ora_mining_varchar2_nt, part_a_pos IN sys.ora_mining_number_nt, part_a_dty IN sys.ora_mining_number_nt, part_a_hiboundlen IN sys.ora_mining_number_nt, part_a_hiboundval IN sys.ora_mining_varchar2_nt, part_b_name IN sys.ora_mining_varchar2_nt, part_b_pos IN sys.ora_mining_number_nt, part_b_dty IN sys.ora_mining_number_nt, pcc IN NUMBER, is_sqlplus IN NUMBER);

TBD