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 Model Export
AUTHID
CURRENT_USER
Dependencies
ALL_MINING_MODELS
DBMS_SYS_ERROR
MODELPARTCOL$
ALL_TAB_PRIVS
DMP_SEC
MODELSET$
COM$
DM_QGEN
MODELXFM$
DBA_MINING_MODELS
DM_TRANSFORM
OBJ$
DBA_MINING_MODEL_TABLES
DM_TRANSFORMS
ODM_MODEL_UTIL
DBMS_ASSERT
KU$_STATUS
ORA_MINING_NUMBER_NT
DBMS_DATAPUMP
MODEL$
ORA_MINING_VARCHAR2_NT
DBMS_DM_EXP_INTERNAL
MODELATT$
PLITBLM
DBMS_STANDARD
MODELPART$
USER$
Documented
No
First Available
Not Known
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/prvtdmsu.plb
Subprograms
AUDIT_EXP
Undocumented
dbms_dm_model_exp.audit_exp(
objid IN NUMBER,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
TDB
AUDIT_SYSPRIVS_EXP
Undocumented
dbms_dm_model_exp.audit_sysprivs_exp(
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
TDB
CREATE_EXP
Undocumented
dbms_dm_model_exp.create_exp(
objid IN NUMBER,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
TDB
GRANT_EXP
Undocumented
dbms_dm_model_exp.grant_exp(
objid IN NUMBER,
isdba IN BINARY_INTEGER,
grantor OUT VARCHAR2,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
TDB
GRANT_SYSPRIVS_EXP
Undocumented
dbms_dm_model_exp.grant_sysprivs_exp(
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
nblk BINARY_INTEGER;
retVal dbms_id;
BEGIN
retVal := dbms_dm_model_exp.grant_sysprivs_exp ('21.0.0.0', nblk);
dbms_output.put_line('New Block: ' || TO_CHAR(nblk));
dbms_output.put_line('Return Val:' || retVal);
END;
/
New Block: 0
Return Val:
PL/SQL procedure successfully completed.