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

TABLE: ASG.ASG_TEMP_LOB

Object Details
Object Name: ASG_TEMP_LOB
Object Type: TABLE
Owner: ASG
Subobject Name:
Status: VALID


Used in out-queue definition of publication items with BLOB/CLOB columns.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000323483C00001$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000323483C00002$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
CLOB_COL CLOB (4000)
Stores CLOB
BLOB_COL BLOB (4000)
Stores BLOB
Query Text

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


SELECT CLOB_COL
,      BLOB_COL
FROM ASG.ASG_TEMP_LOB;

Dependencies

[top of page]

ASG.ASG_TEMP_LOB does not reference any database object

ASG.ASG_TEMP_LOB is referenced by following:

SchemaAPPS
SynonymASG_TEMP_LOB