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

TABLE: APPLSYS.AD_PROCESSED_FILES_TEMP

Object Details
Object Name: AD_PROCESSED_FILES_TEMP
Object Type: TABLE
Owner: APPLSYS
Subobject Name:
Status: VALID

Temporary Table Details

APPLSYS.AD_PROCESSED_FILES_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Unique Key: SYS_C00187656
  1. ColumnPRODUCT_SHORT_NAME
  2. ColumnSUBDIR
  3. ColumnFILE_BASE
  4. ColumnFILE_EXTENSION
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00187656 NORMAL UNIQUE Tablespace ColumnPRODUCT_SHORT_NAME
ColumnSUBDIR
ColumnFILE_BASE
ColumnFILE_EXTENSION
Columns
Name Datatype Length Mandatory Comments
PRODUCT_SHORT_NAME VARCHAR2 (50)
SUBDIR VARCHAR2 (256)
FILE_BASE VARCHAR2 (128)
FILE_EXTENSION VARCHAR2 (50)
FILE_ID NUMBER

FILE_VERSION_ID NUMBER

VERSION VARCHAR2 (150)
DATE_APPLIED DATE

ADPATCH_FLAG VARCHAR2 (1)
Query Text

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


SELECT PRODUCT_SHORT_NAME
,      SUBDIR
,      FILE_BASE
,      FILE_EXTENSION
,      FILE_ID
,      FILE_VERSION_ID
,      VERSION
,      DATE_APPLIED
,      ADPATCH_FLAG
FROM APPLSYS.AD_PROCESSED_FILES_TEMP;

Dependencies

[top of page]

APPLSYS.AD_PROCESSED_FILES_TEMP does not reference any database object

APPLSYS.AD_PROCESSED_FILES_TEMP is referenced by following:

SchemaAPPS
SynonymAD_PROCESSED_FILES_TEMP