Oracle | DBMS_EXPORT_EXTENSION_I

Oracle DBMS_EXPORT_EXTENSION_I 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 Undocumented internal functions called by DBMS_EXPORT_EXTENSION to dynamically link in PL/SQL logic in the export process.

AUTHID DEFINER

Dependencies

COL$	DBMS_STANDARD	EXPTABSUBPARTDATA_VIEW
COM$	DBMS_SYSTEM	EXPTABSUBPARTLOB_VIEW
DBMS_ASSERT	DBMS_SYS_ERROR	PARTLOB$
DBMS_EXPORT_EXTENSION	EXPACT$	TABCOMPART$
DBMS_LOB

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted the EXECUTE_CATALOG_ROLE role

Direct access to this package is prevented by means of an Accessible By clause. The package's functionality is available through DBMS_EXPORT_EXTENSION.

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

Subprograms

CHECK_MATCH_TEMPLATE	SET_EXP_OPQ_TYP_EVENT	SET_NLS_NUMERIC_CHAR
FUNC_INDEX_DEFAULT	SET_EXP_SORTSIZE	SET_NO_OUTLINES
GET_LOBCOLCNT	SET_EXP_TIMEZONE	SET_RESUM
GET_OBJECT_COMMENT	SET_HAKAN_EVENT	SET_RESUMNAM
GET_TABACT	SET_IMP_EVENTS	SET_RESUMNAMTIM
INSERT_SECOBJ	SET_IMP_SKIP_INDEXES_OFF	SET_RESUMTIM
NULLTOCHR0	SET_IMP_SKIP_INDEXES_ON	SET_SECONDARYOBJ_EVENT
RESET_EXP_OPQ_TYP_EVENT	SET_IMP_TIMEZONE	SET_STATSON
RESET_NLS_NUMERIC_CHAR	SET_IOT_EVENT	TRUNCATE_SECOBJ
RESET_SECONDARYOBJ_EVENT

CHECK_MATCH_TEMPLATE

Undocumented

Appears to be protected by accessible by clause dbms_export_extension_i.set_imp_skip_indexes_off(pobjno IN NUMBER) RETURN NUMBER;

conn / as sysdba

      

      DECLARE

       retVal NUMBER;

      BEGIN

        retVal := dbms_export_extension_i.set_imp_skip_indexes_off(1);

        dbms_output.put_line(TO_CHAR(retVal));

      END;

      /

      ERROR at line 4:

      ORA-06550: line 4, column 13:

      PLS-00904: insufficient privilege to access object DBMS_EXPORT_EXTENSION_I

      ORA-06550: line 4, column 3:

      PL/SQL: Statement ignored

FUNC_INDEX_DEFAULT

Undocumented

Appears to be protected by accessible by clause dbms_export_extension_i.func_index_default( tabobj IN NUMBER, colname IN VARCHAR2) RETURN CLOB;

conn / as sysdba

      

      CREATE TABLE t(

      testcol DATE);

      

      ALTER TABLE t

      ADD CONSTRAINT pk_t

      PRIMARY KEY(testcol);

      

      SELECT object_id, object_type

      FROM user_objects

      WHERE object_name = 'PK_T';

      

      SELECT dbms_export_extension_i.func_index_default(92814, 'TESTCOL')

      FROM dual;

      ERROR at line 1:

      ORA-06552: PL/SQL: Statement ignored

      ORA-06553: PLS-904: insufficient privilege to access object DBMS_EXPORT_EXTENSION_I

Undocumented dbms_export_extension_i.get_lobcolcnt(pobjno IN NUMBER) RETURN NUMBER;

Protected by an ACCESSIBLE BY clause

GET_OBJECT_COMMENT

Undocumented dbms_export_extension_i.get_object_comment( objid IN NUMBER, objtype IN NUMBER) RETURN VARCHAR2;

Protected by an ACCESSIBLE BY clause

Undocumented dbms_export_extension_i.get_tabact( obj_schema IN VARCHAR2, obj_name IN VARCHAR2, expt_func IN NUMBER, func_package OUT VARCHAR2, func_proc OUT VARCHAR2, user_arg OUT VARCHAR2, callarg OUT VARCHAR2) RETURN NUMBER;

Protected by an ACCESSIBLE BY clause

Undocumented dbms_export_extension_i.insert_secobj( domidxschema IN VARCHAR2, domidxname IN VARCHAR2, secobjschema IN VARCHAR2, secobjname IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

Undocumented dbms_export_extension_i.nulltochr0(value IN VARCHAR2) RETURN VARCHAR2;

Protected by an ACCESSIBLE BY clause

RESET_EXP_OPQ_TYP_EVENT

Undocumented dbms_export_extension_i.reset_exp_opq_typ_event;

Protected by an ACCESSIBLE BY clause

RESET_NLS_NUMERIC_CHAR

Undocumented dbms_export_extension_i.reset_nls_numeric_char;

Protected by an ACCESSIBLE BY clause

RESET_SECONDARYOBJ_EVENT

Undocumented dbms_export_extension_i.reset_secondary_obj_event;

Protected by an ACCESSIBLE BY clause

SET_EXP_OPQ_TYP_EVENT

Undocumented dbms_export_extension_i.set_exp_opq_typ_event;

Protected by an ACCESSIBLE BY clause

SET_EXP_SORTSIZE

Undocumented dbms_export_extension_i.set_exp_sortsize;

Protected by an ACCESSIBLE BY clause

SET_EXP_TIMEZONE

Undocumented dbms_export_extension_i.set_exp_timezone;

Protected by an ACCESSIBLE BY clause

SET_HAKAN_EVENT

Undocumented dbms_export_extension_i.set_hakan_event;

Protected by an ACCESSIBLE BY clause

Undocumented dbms_export_extension_i.set_imp_events;

Protected by an ACCESSIBLE BY clause

SET_IMP_SKIP_INDEXES_OFF

Undocumented dbms_export_extension_i.set_imp_skip_indexes_off;

Protected by an ACCESSIBLE BY clause

SET_IMP_SKIP_INDEXES_ON

Undocumented dbms_export_extension_i.set_imp_skip_indexes_on;

Protected by an ACCESSIBLE BY clause

SET_IMP_TIMEZONE

Undocumented

Appears to be protected by accessible by clause dbms_export_extension_i.set_imp_timezone(timezone IN VARCHAR2);

exec dbms_export_extension_i.set_imp_timezone('US/Pacific');

      BEGIN dbms_export_extension_i.set_imp_timezone('US/Pacific'); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_EXPORT_EXTENSION_I

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

Undocumented dbms_export_extension_i.set_iot_event;

Protected by an ACCESSIBLE BY clause

SET_NLS_NUMERIC_CHAR

Undocumented dbms_export_extension_i.set_nls_numeric_char;

Protected by an ACCESSIBLE BY clause

SET_NO_OUTLINES

Undocumented dbms_export_extension_i.set_no_outlines;

Protected by an ACCESSIBLE BY clause

Undocumented dbms_export_extension_i.set_resum;

Protected by an ACCESSIBLE BY clause

Undocumented dbms_export_extension_i.set_resumnam(name IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

SET_RESUMNAMTIM

Undocumented dbms_export_extension_i.set_resumnamtim( name IN VARCHAR2, time IN NUMBER);

Protected by an ACCESSIBLE BY clause

Undocumented

Appears to be protected by accessible by clause dbms_export_extension_i.set_resumtim(time IN NUMBER);

exec dbms_export_extension_i.set_resumtim(1);

      BEGIN dbms_export_extension_i.set_resumtim(1); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_EXPORT_EXTENSION_I

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

SET_SECONDARYOBJ_EVENT

Undocumented dbms_export_extension_i.set_secondearyobj_event;

Protected by an ACCESSIBLE BY clause

Undocumented dbms_export_extension_i.set_statson;

Protected by an ACCESSIBLE BY clause

TRUNCATE_SECOBJ

Undocumented dbms_export_extension_i.truncate_secobj;

Protected by an ACCESSIBLE BY clause

Related Topics

Built-in Functions

Built-in Packages

DBMS_EXPORT_EXTENSION

What's New In 21c

What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved