Oracle | DMP

Oracle DMP_SEC Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Data Mining Predictive Analytics Support Utilities

AUTHID DEFINER

Dependencies

ALL_MINING_MODELS	DBMS_DM_MODEL_EXP	DM_QGEN
ALL_TABLES	DBMS_DM_MODEL_IMP	MODEL$
COL$	DBMS_DM_UTIL	MODELALG_SEQ$
COLTYPE$	DBMS_PREDICTIVE_ANALYTICS	OBJ$
DBA_MINING_MODELS	DBMS_STANDARD	ODM_MODEL_UTIL
DBA_MINING_MODEL_ATTRIBUTES	DBMS_STATS	ODM_UTIL
DBA_MINING_MODEL_TABLES	DBMS_SYS_ERROR	ORA_MINING_VARCHAR2_NT
DBMS_ASSERT	DBMS_UTILITY	PLITBLM
DBMS_DATAPUMP	DMP_SYS	TAB$
DBMS_DATA_MINING	DMUTIL_LIB	USER$
DBMS_DATA_MINING_INTERNAL	DM_ITEM	V$PARAMETER
DBMS_DATA_MINING_TRANSFORM	DM_ITEMS	_CURRENT_EDITION_OBJ
DBMS_DM_EXP_INTERNAL

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtdmsu.plb

Subprograms

ADD_MODEL_TABLE	GET_FUNCTION_NAME	GET_MODEL_DETAILS_OC
CHECK_SCHEMA	GET_MODEL_COST_MATRIX	GET_MODEL_DETAILS_SVD
CREATE_EMPTY_MODEL	GET_MODEL_DETAILS_AI	GET_MODEL_DETAILS_SVM
DROP_ALGORITHM_INTERNAL	GET_MODEL_DETAILS_EM	GET_MODEL_DETAILS_TREE_XML
DROP_MODEL_TABLES	GET_MODEL_DETAILS_EM_COMP	GET_MODEL_TABLE
DROP_TABLE	GET_MODEL_DETAILS_EM_PROJ	GET_MODEL_TABLES
FETCH_ALG_SCHEMA_INTERNAL	GET_MODEL_DETAILS_GLM	INSERT_ALGORITHM
GATHER_MODEL_STATS	GET_MODEL_DETAILS_GLOBAL	LOAD_MODEL
GET_ALGORITHM_NAME	GET_MODEL_DETAILS_KM	MODEL_EXISTS
GET_ASSOCIATION_RULES	GET_MODEL_DETAILS_NB	RECKON_TABLE_SIZE
GET_FREQUENT_ITEMSETS	GET_MODEL_DETAILS_NMF

ADD_MODEL_TABLE

Undocumented dmp_sec.add_model_table( model_name IN VARCHAR2, table_type IN VARCHAR2, table_name IN VARCHAR2, owner_num IN NUMBER);

TBD

CHECK_SCHEMA

Undocumented dmp_sec.check_schema( schema_content IN VARCHAR2, schema_type IN NUMBER, res IN OUT BINARY_INTEGER);

TBD

CREATE_EMPTY_MODEL

Undocumented dmp_sec.create_empty_model( model_name IN VARCHAR2, mining_function IN VARCHAR2, algorithm IN VARCHAR2, target_attribute IN VARCHAR2, build_duration IN NUMBER, model_size IN NUMBER, build_version IN NUMBER, user_no IN NUMBER, user_name IN VARCHAR2);

TBD

DROP_ALGORITHM_INTERNAL

Undocumented dmp_sec.drop_algorithm_internal(algorithm_name IN VARCHAR2);

SELECT table_name

      FROM dba_tab_cols

      WHERE column_name = 'ALGORITHM_NAME'

      ORDER BY 1;

      

      TABLE_NAME

      -------------------------------

      ALL_MINING_ALGORITHMS

      DM_USER_MODELS

      GV_$RMAN_COMPRESSION_ALGORITHM

      V_$RMAN_COMPRESSION_ALGORITHM

      V_$RMAN_ENCRYPTION_ALGORITHMS

DROP_MODEL_TABLES

Drops the tables in a model by schema dmp_sec.drop_model_tables( model_name IN VARCHAR2, schema_name IN VARCHAR2);

TBD

DROP_TABLE

Drops any heap normal heap table. Presumably drops any table other than blockchain or immutable but other table types remain to be tested. dmp_sec.drop_table( table_name IN VARCHAR2, schema_name IN VARCHAR2);

CREATE TABLE c##uwclass.test AS

      SELECT * FROM user_tables;

      

      Table created.

      

      exec dmp_sec.drop_table('TEST', 'C##UWCLASS');

      

      SQL> desc c##uwclass.test

      ERROR:

      ORA-04043: object c##uwclass.test does not exist

FETCH_ALG_SCHEMA_INTERNAL

Undocumented dmp_sec.fetch_alg_schema_internal RETURN CLOB;

SELECT dmp_sec.fetch_alg_schema_internal;

      

      FETCH_ALG_SCHEMA_INTERNAL

      --------------------------------------------------------------------------------

      {

        "type": "object",

        "properties": {

          "algo_name_display": { "type" : "object", "properties" : { "language" : { "type" : "string","enum" : ["English", "Spanish", "French"], "default" : "English"}, "name" : { "type" : "string"}

              }

            },

          "function_language": {"type": "string" },

          "mining_function": {

            "type" : "object",

            "properties" :

              { "type" : "object",

                "properties" : {

                  "mining_function_name" : { "type" : "string"},

                  "build_function": {

                    "type": "object",

                    "properties": { "function_body": { "type": "CLOB," }

                      }

                    },

                  "detail_function": {

                    "type" : "array",

                    "items" : [

      ...

                "categorical choices" : { "type": "array",
      "items": {"type": "string"

                     }

                   },

                "description_display": { "type" : "object",

                  "properties" : { 

                    "language" : { "type" : "string", "enum" : ["English", "Spanish",

                    "French"], "default" : "English"}, "name" : { "type" : "string"}}

                  }

                }

              }

            ]

          }

        }

      }

GATHER_MODEL_STATS

Undocumented dmp_sec.gather_model_stats( model_name IN VARCHAR2, schema_name IN VARCHAR2);

TBD

GET_ALGORITHM_NAME

Undocumented dmp_sec.get_algorithm_name( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_ASSOCIATION_RULES

Undocumented dmp_sec.get_association_rules( model_name IN VARCHAR2, schema_name IN VARCHAR2, topn IN NUMBER, rule_id IN NUMBER, min_confidence IN NUMBER, min_support IN NUMBER, min_lift IN NUMBER, max_rule_length IN NUMBER, min_rule_length IN NUMBER, sort_order IN sys.ora_mining_varchar2_nt, antecedent_items IN sys.dm_items, 1consequent_items IN sys.dm_items, 1partition_name IN VARCHAR2, 1partitioned IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_FREQUENT_ITEMSETS

Undocumented dmp_sec.get_frequent_itemset( model_name IN VARCHAR2, schema_name IN VARCHAR2, topn IN NUMBER, max_itemset_length IN NUMBER, partition_name IN VARCHAR2, partitioned IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_FUNCTION_NAME

Undocumented dmp_sec.get_function_name( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_COST_MATRIX

Undocumented dmp_sec.get_model_cost_matrix( model_name IN VARCHAR2, schema_name IN VARCHAR2, partitioned IN VARCHAR2, partition_name IN VARCHAR2, matrix_type IN VARCHAR2);

TBD

GET_MODEL_DETAILS_AI

Undocumented dmp_sec.get_model_details_ai( model_rec IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_EM

Undocumented dmp_sec.get_model_details_em( model IN sys.odm_model_util.model_rec, schema_name IN VARCHAR2, cluster_id IN NUMBER, attribute IN VARCHAR2, centroid IN NUMBER, histogram IN NUMBER, rules IN NUMBER, attribute_subname IN VARCHAR2, topn_attributes IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_EM_COMP

Undocumented dmp_sec.get_model_details_em_comp( model IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_EM_PROJ

Undocumented dmp_sec.get_model_details_em_proj( model IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_GLM

Undocumented dmp_sec.get_model_details_glm( model_name IN VARCHAR2, schema_name IN VARCHAR2, model_rec IN sys.odm_model_util.model_rec, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_GLOBAL

Undocumented dmp_sec.get_model_details_global( model IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_KM

Undocumented dmp_sec.get_model_details_km( model IN sys.odm_model_util.model_rec, schema_name IN VARCHAR2, cluster_id IN NUMBER, attribute IN VARCHAR2, centroid IN NUMBER, histogram IN NUMBER, rules IN NUMBER, attribute_subname IN VARCHAR2, bulk_collect_num_rows IN OUT NUMBER, topn_attributes IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_NB

Undocumented dmp_sec.get_model_details_nb( model_rec IN sys.odm_model_util.model_rec, model_name IN VARCHAR2, schema_name IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_NMF

Undocumented dmp_sec.get_model_details_nmf( model_name IN VARCHAR2, schema_name IN VARCHAR2, model_rec IN sys.odm_model_util.model_rec, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_OC

Undocumented dmp_sec.get_model_details_oc( model IN sys.odm_model_util.model_rec, schema_name IN VARCHAR2, cluster_id IN NUMBER, attribute IN VARCHAR2, centroid IN NUMBER, histogram IN NUMBER, rules IN NUMBER, topn_attributes IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_SVD

Undocumented dmp_sec.get_model_details_svd( model_name IN VARCHAR2, schema_name IN VARCHAR2, model_rec IN sys.odm_model_util.model_rec, matrix_type IN VARCHAR2, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_SVM

Undocumented dmp_sec.get_model_details_svm( model_name IN VARCHAR2, schema_name IN VARCHAR2, model IN sys.odm_model_util.model_rec, reverse_coef IN NUMBER, partition_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_DETAILS_TREE_XML

Undocumented dmp_sec.get_model_details_tree_xml( model_name IN VARCHAR2, schema_name IN VARCHAR2, stmt IN OUT sys.dbms_sql.varchar2s, stmtlen IN OUT BINARY_INTEGER, stmt_scoredist IN OUT VARCHAR2, stmt_split IN OUT VARCHAR2, stmt_splitcnt IN OUT VARCHAR2, stmt_splitcat IN OUT VARCHAR2, basepred IN OUT sys.dbms_sql.varchar2s, basepredcnt IN OUT BINARY_INTEGER, partition_name IN VARCHAR2, partitioned IN VARCHAR2);

TBD

GET_MODEL_TABLE

Undocumented dmp_sec.get_model_table( p_model_name IN VARCHAR2, p_table_type IN VARCHAR2, p_user_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_MODEL_TABLES

Undocumented dmp_sec.get_model_tables( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN sys.odm_model_util.model_tables_list;

TBD

INSERT_ALGORITHM

Undocumented dmp_sec.insert_algorithm( algorithm_name IN VARCHAR2, mining_function IN NUMBER, algorithm_type IN VARCHAR2, algorithm_metadata IN CLOB, algorithm_description IN VARCHAR2);

TBD

LOAD_MODEL

Undocumented dmp_sec.load_model( p_model_name IN VARCHAR2, p_owner_name IN VARCHAR2, p_partition_name_in IN VARCHAR2, p_partition_name_out OUT VARCHAR2, p_validate_pname IN BOOLEAN, p_load_settings IN BOOLEAN, p_load_xforms IN BOOLEAN) RETURN sys.odm_model_util.model_rec;

TBD

MODEL_EXISTS

Undocumented dmp_sec.model_exists( p_model_name IN VARCHAR2, p_user_name IN VARCHAR2) RETURN BOOLEAN;

TBD

RECKON_TABLE_SIZE

Undocumented dmp_sec.reckon_table_size( user_name IN VARCHAR2, table_name IN VARCHAR2, has_stats IN NUMBER, block_size IN OUT NUMBER) RETURN NUMBER;

TBD