Oracle DMP_SEC
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 DEFINER
Dependencies
ALL_MINING_MODELS DBMS_DM_EXP_INTERNAL DM_ITEMS
ALL_TABLES DBMS_DM_MODEL_EXP DM_QGEN
COL$ DBMS_DM_MODEL_IMP MODELALG_SEQ$
COLTYPE$ DBMS_DM_UTIL OBJ$
DBA_MINING_MODELS DBMS_PREDICTIVE_ANALYTICS ODM_MODEL_UTIL
DBA_MINING_MODEL_ATTRIBUTES DBMS_STANDARD ODM_UTIL
DBA_MINING_MODEL_TABLES DBMS_STATS ORA_MINING_VARCHAR2_NT
DBMS_ASSERT DBMS_SYS_ERROR PLITBLM
DBMS_DATAPUMP DBMS_UTILITY TAB$
DBMS_DATA_MINING DMP_SYS USER$
DBMS_DATA_MINING_INTERNAL DMUTIL_LIB V$PARAMETER
DBMS_DATA_MINING_TRANSFORM DM_ITEM _CURRENT_EDITION_OBJ
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
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##safedba.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
FROM dual;

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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DMP_SYS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx