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.
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;
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
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