Oracle DBMSOBJG_DP
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
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    
First available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtbog3.plb
 
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;
/

Related Topics
DataPump Executable
DBMS_DATAPUMP
DBMS_SQL
DBMS_UTILITY
Packages

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