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
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
 
GET_LOBCOLCNT
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
 
GET_TABACT
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
 
INSERT_SECOBJ
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
 
NULLTOCHR0
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
 
SET_IMP_EVENTS
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
 
SET_IOT_EVENT
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
 
SET_RESUM
Undocumented dbms_export_extension_i.set_resum;
Protected by an ACCESSIBLE BY clause
 
SET_RESUMNAM
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
 
SET_RESUMTIM
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
 
SET_STATSON
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
  DBSecWorx