Oracle | DBMS_EXPORT_EXTENSION_I

Oracle DBMS_EXPORT_EXTENSION_I 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 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 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