Oracle | DBMS_DM_MODEL

Oracle DBMS_DM_MODEL_EXP 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 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	CREATE_EXP	GRANT_SYSPRIVS_EXP
AUDIT_SYSPRIVS_EXP	GRANT_EXP

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.