Oracle | DBMS_DM_MODEL

Oracle DBMS_DM_MODEL_EXP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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('23.4.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.