 |
|
DBMSOBJG package tips
Oracle Tips by Burleson Consulting |
DBMSOBJG
<< Return to the index
Oracle 11g provides the following information about the DBMSOBJG package:
Description of the DBMSOBJG package:
PROCEDURE DBMSOBJG.CHECK_PERMISSIONS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SNAME VARCHAR2 IN
ONAME VARCHAR2 IN
TYPE VARCHAR2 IN
FUNCTION DBMSOBJG.FIND_COL_INFO RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COLUMN_NAME VARCHAR2 IN
COLTAB TABLE OF VARCHAR2(30) IN
FUNCTION DBMSOBJG.FIND_TS_INFO RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLESPACE_NAME VARCHAR2 IN
TSTAB TABLE OF VARCHAR2(30) IN
TSCNT NUMBER(38) IN
PROCEDURE DBMSOBJG.GENERATE_DDL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SNAME VARCHAR2 IN
ONAME VARCHAR2 IN
TYPE VARCHAR2 IN
FLAVOR_COLUMNS TABLE OF VARCHAR2(30) IN
TABLESPACE VARCHAR2 OUT
DDLTAB TABLE OF VARCHAR2(256) OUT
DDLLEN_TAB TABLE OF NUMBER OUT
USE_TABLESPACE VARCHAR2 IN
CREATE_STORAGE VARCHAR2 IN
DISABLED_TRIG VARCHAR2 OUT
FORCE_VIEW VARCHAR2 IN
DEBUG_TABLE VARCHAR2 IN
DDLCNT NUMBER(38) OUT
TSTAB TABLE OF VARCHAR2(30) IN DEFAULT
TSCNT NUMBER(38) IN DEFAULT
PROCEDURE DBMSOBJG.GENERATE_DDL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SNAME VARCHAR2 IN
ONAME VARCHAR2 IN
TYPE VARCHAR2 IN
FLAVOR_COLUMNS TABLE OF VARCHAR2(30) IN
TABLESPACE VARCHAR2 OUT
DDLTAB TABLE OF VARCHAR2(256) IN/OUT
USE_TABLESPACE VARCHAR2 IN
CREATE_STORAGE VARCHAR2 IN
DISABLED_TRIG VARCHAR2 OUT
DISABLED_TRIG_DDL TABLE OF VARCHAR2(256) IN/OUT
FORCE_VIEW VARCHAR2 IN
DEBUG_TABLE VARCHAR2 IN
DDLCNT NUMBER(38) IN/OUT
DISABLEDCNT NUMBER(38) IN/OUT
TSTAB TABLE OF VARCHAR2(30) IN DEFAULT
TSCNT NUMBER(38) IN DEFAULT
FUNCTION DBMSOBJG.GET_NLS_SUBSTR RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
S VARCHAR2 IN
OFFSET NUMBER IN/OUT
LEN NUMBER IN
PROCEDURE DBMSOBJG.GET_TAB_SPACE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SNAME VARCHAR2 IN
ONAME VARCHAR2 IN
OTYPE VARCHAR2 IN
TSPACETAB TABLE OF VARCHAR2(30) OUT
TSPACECNT NUMBER(38) OUT
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
