Oracle DBMS_EXPORT_EXTENSION_I
Version 18.3

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.0.2
Security Model Owned by SYS with EXECUTE granted the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/prvthpexpi.plb
Subprograms
 
CHECK_MATCH_TEMPLATE
Undocumented 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 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;
TBD
 
GET_OBJECT_COMMENT
Undocumented dbms_export_extension_i.get_object_comment(
objid   IN NUMBER,
objtype IN NUMBER)
RETURN VARCHAR2;
TBD
 
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;
TBD
 
INSERT_SECOBJ
Undocumented dbms_export_extension_i.insert_secobj(
domidxschema IN VARCHAR2,
domidxname   IN VARCHAR2,
secobjschema IN VARCHAR2,
secobjname   IN VARCHAR2);
TBD
 
NULLTOCHR0
Undocumented dbms_export_extension_i.nulltochr0(value IN VARCHAR2) RETURN VARCHAR2;
TBD
 
RESET_EXP_OPQ_TYP_EVENT
Undocumented dbms_export_extension_i.reset_exp_opq_typ_event;
exec dbms_export_extension_i.reset_exp_opq_typ_event;
 
RESET_NLS_NUMERIC_CHAR
Undocumented dbms_export_extension_i.reset_nls_numeric_char;
exec dbms_export_extension_i.reset_nls_numeric_char;
 
RESET_SECONDARYOBJ_EVENT
Undocumented dbms_export_extension_i.reset_secondary_obj_event;
exec dbms_export_extension_i.reset_secondary_obj_event;
 
SET_EXP_OPQ_TYP_EVENT
Undocumented dbms_export_extension_i.set_exp_opq_typ_event;
exec dbms_export_extension_i.set_exp_opq_typ_event;
 
SET_EXP_SORTSIZE
Undocumented dbms_export_extension_i.set_exp_sortsize;
exec dbms_export_extension_i.set_exp_sortsize;
 
SET_EXP_TIMEZONE
Undocumented dbms_export_extension_i.set_exp_timezone;
exec dbms_export_extension_i.set_exp_timezone;
 
SET_HAKAN_EVENT
Undocumented dbms_export_extension_i.set_hakan_event;
exec dbms_export_extension_i.set_hakan_event;
 
SET_IMP_EVENTS
Undocumented dbms_export_extension_i.set_imp_events;
exec dbms_export_extension_i.set_imp_events;
 
SET_IMP_SKIP_INDEXES_OFF
Undocumented dbms_export_extension_i.set_imp_skip_indexes_off;
exec dbms_export_extension_i.set_imp_skip_indexes_off;
 
SET_IMP_SKIP_INDEXES_ON
Undocumented dbms_export_extension_i.set_imp_skip_indexes_on;
exec dbms_export_extension_i.set_imp_skip_indexes_on;
 
SET_IMP_TIMEZONE
Undocumented dbms_export_extension_i.set_imp_timezone(timezone IN VARCHAR2);
TBD
 
SET_IOT_EVENT
Undocumented dbms_export_extension_i.set_iot_event;
exec dbms_export_extension_i.set_iot_event;
 
SET_NLS_NUMERIC_CHAR
Undocumented dbms_export_extension_i.set_nls_numeric_char;
exec dbms_export_extension_i.set_nls_numeric_char;
 
SET_NO_OUTLINES
Undocumented dbms_export_extension_i.set_no_outlines;
exec dbms_export_extension_i.set_no_outlines;
 
SET_RESUM
Undocumented dbms_export_extension_i.set_resum;
exec dbms_export_extension_i.set_resum;
 
SET_RESUMNAM
Undocumented dbms_export_extension_i.set_resumnam(name IN VARCHAR2);
TBD
 
SET_RESUMNAMTIM
Undocumented dbms_export_extension_i.set_resumnamtim(
name IN VARCHAR2,
time IN NUMBER);
TBD
 
SET_RESUMTIM
Undocumented dbms_export_extension_i.set_resumtim(time IN NUMBER);
TBD
 
SET_SECONDARYOBJ_EVENT
Undocumented dbms_export_extension_i.set_secondearyobj_event;
exec dbms_export_extension_i.set_secondearyobj_event;
 
SET_STATSON
Undocumented dbms_export_extension_i.set_statson;
exec dbms_export_extension_i.set_statson;
 
TRUNCATE_SECOBJ
Undocumented dbms_export_extension_i.truncate_secobj;
exec dbms_export_extension_i.truncate_secobj;

Related Topics
Built-in Functions
Built-in Packages
DBMS_EXPORT_EXTENSION
What's New In 18c
What's New In 19c

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