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


TABLE: SYS.APPLY$_SOURCE_OBJ

Object Details
Object Name: APPLY$_SOURCE_OBJ
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_APPLY_SOURCE_OBJ1 NORMAL UNIQUE TablespaceSYSTEM ColumnID
I_APPLY_SOURCE_OBJ2 NORMAL UNIQUE TablespaceSYSTEM ColumnOWNER
ColumnNAME
ColumnTYPE
ColumnSOURCE_DB_NAME
ColumnDBLINK
ColumnSOURCE_ROOT_NAME
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
OWNER VARCHAR2 (128) Yes
NAME VARCHAR2 (128) Yes
TYPE NUMBER
Yes
SOURCE_DB_NAME VARCHAR2 (128) Yes
DBLINK VARCHAR2 (128)
INST_SCN NUMBER

IGNORE_SCN NUMBER

SPARE1 NUMBER

INST_EXTERNAL_POS RAW (64)
SPARE2 VARCHAR2 (4000)
SPARE3 RAW (2000)
SOURCE_ROOT_NAME VARCHAR2 (128)
Query Text

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


SELECT ID
,      OWNER
,      NAME
,      TYPE
,      SOURCE_DB_NAME
,      DBLINK
,      INST_SCN
,      IGNORE_SCN
,      SPARE1
,      INST_EXTERNAL_POS
,      SPARE2
,      SPARE3
,      SOURCE_ROOT_NAME
FROM SYS.APPLY$_SOURCE_OBJ;

Dependencies

[top of page]

SYS.APPLY$_SOURCE_OBJ does not reference any database object

SYS.APPLY$_SOURCE_OBJ is referenced by following:

SchemaSYS
View_DBA_APPLY_SOURCE_OBJ