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

TABLE: SYS.WI$_CAPTURE_FILE

Object Details
Object Name: WI$_CAPTURE_FILE
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WI$_CAPTURE_FILE_PK
  1. ColumnJOBID
  2. ColumnFILEID
Indexes
Index Type Uniqueness Tablespace Column
WI$_CAPTURE_FILE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnJOBID
ColumnFILEID
Foreign Keys
Table
Foreign Table Foreign Key Column
WI$_CAPTURE_FILE WI$_CAPTURE_FILE_FK1 TableWI$_JOB WI$_CAPTURE_FILE JOBID
TableWI$_EXECUTION_ORDER WI$_EXECUTION_ORDER_FK1 WI$_CAPTURE_FILE WI$_EXECUTION_ORDER JOBID
WI$_EXECUTION_ORDER FILEID
Columns
Name Datatype Length Mandatory Comments
JOBID NUMBER
Yes
FILEID NUMBER
Yes
PATH VARCHAR2 (4000) Yes
Query Text

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


SELECT JOBID
,      FILEID
,      PATH
FROM SYS.WI$_CAPTURE_FILE;

Dependencies

[top of page]

SYS.WI$_CAPTURE_FILE does not reference any database object

SYS.WI$_CAPTURE_FILE is referenced by following:

SchemaSYS
ViewDBA_WI_CAPTURE_FILES