DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS._ALL_INSTANTIATION_DDL

Object Details
Object Name: _ALL_INSTANTIATION_DDL
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Table containing supplementary DDL to be executed during instantiation.

[View Source]

Columns
Name Datatype Length Mandatory Comments
REFRESH_TEMPLATE_ID NUMBER
Yes Primary key of template containing supplementary DDL.
DDL_TEXT CLOB (4000)
Supplementary DDL string.
DDL_NUM NUMBER
Yes Column for ordering of supplementary DDL.
PHASE NUMBER
Yes Phase to execute the DDL string.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REFRESH_TEMPLATE_ID
,      DDL_TEXT
,      DDL_NUM
,      PHASE
FROM SYS._ALL_INSTANTIATION_DDL;

Dependencies

[top of page]

SYS._ALL_INSTANTIATION_DDL references the following:

SchemaSYSTEM
TableREPCAT$_INSTANTIATION_DDL
SYS._ALL_INSTANTIATION_DDL is referenced by following:

SchemaPUBLIC
Synonym_ALL_INSTANTIATION_DDL