Oracle DBMSOBJG

Oracle DBMSOBJG_DP Version 11.2.0.3

General Information

Purpose

Undocumented internal support package for DataPump object generation

AUTHID

DEFINER

Dependencies

ALL_INDEXES	DBMS_REPCAT_SQL_UTL	KU$_DDLS
COL$	DBMS_REPCAT_UTL	KU$_PARSED_ITEM
DBMSOBJG	DBMS_SYS_ERROR	KU$_PARSED_ITEMS
DBMS_ASSERT	DBMS_SYS_SQL	OBJ$
DBMS_METADATA	DBMS_UTILITY	PLITBLM
DBMS_REPCAT_DECL	KU$_DDL	USER$
DBMS_REPCAT_OBJ_UTL

Security Model

Owned by SYS with no privileges granted

Source

{ORACLE_HOME}/rdbms/admin/prvtbog3.plb

Subprograms

GENERATE_DDL_DP

Undocumented

dbmsobjg_dp.generate_ddl_dp(
canon_sname    IN VARCHAR2, -- schema name
canon_oname    IN VARCHAR2, -- object name
type           IN VARCHAR2,
flavor_columns IN dbms_utility.name_array,
tablespace     OUT VARCHAR2,
ddl_tab        OUT dbms_sql.varchar2s,
ddl_lens       OUT dbms_utility.number_array,
use_tablespace IN BOOLEAN,
create_storage IN BOOLEAN,
disabled_trig OUT VARCHAR2,
force_view     IN BOOLEAN,
debug_table    IN VARCHAR2,
ddlcnt         OUT NUMBER);

DECLARE
fcols dbms_utility.name_array;
tbsp VARCHAR2(30);
tab_ddl dbms_sql.varchar2s;
lens_ddl dbms_utility.number_array;
distrig VARCHAR2(30);
cnt_ddl NUMBER;
BEGIN
dbmsobjg_dp.generate_ddl_dp('UWCLASS', 'SERVERS', 'TABLE', fcols, tbsp, tab_ddl, lens_ddl, TRUE, FALSE, distrig, FALSE, 'SERVERS_DEBUG', cnt_ddl);
dbms_output.put_line(tbsp);
dbms_output.put_line(distrig);
dbms_output.put_line(cnt_ddl);
END;
/