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

TABLE: SYS.JIJOIN$

Object Details
Object Name: JIJOIN$
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
I2_JIJOIN$ NORMAL NONUNIQUE TablespaceSYSTEM ColumnTAB1OBJ#
ColumnTAB1COL#
I3_JIJOIN$ NORMAL NONUNIQUE TablespaceSYSTEM ColumnTAB2OBJ#
ColumnTAB2COL#
I_JIJOIN$ NORMAL NONUNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
TAB1OBJ# NUMBER
Yes
TAB1COL# NUMBER
Yes
TAB2OBJ# NUMBER
Yes
TAB2COL# NUMBER
Yes
JOINOP NUMBER
Yes
FLAGS NUMBER

TAB1INST# NUMBER

TAB2INST# NUMBER

Query Text

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


SELECT OBJ#
,      TAB1OBJ#
,      TAB1COL#
,      TAB2OBJ#
,      TAB2COL#
,      JOINOP
,      FLAGS
,      TAB1INST#
,      TAB2INST#
FROM SYS.JIJOIN$;

Dependencies

[top of page]

SYS.JIJOIN$ does not reference any database object

SYS.JIJOIN$ is referenced by following:

SchemaSYS
ViewALL_JOIN_IND_COLUMNS
ViewDBA_JOIN_IND_COLUMNS
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code
ViewEXU9BJF
ViewEXU9BJW
ViewKU$_JIJOIN_TABLE_VIEW
ViewKU$_JIJOIN_VIEW
ViewSTRADDLING_RS_OBJECTS
ViewSTRADDLING_TS_OBJECTS
ViewUSER_JOIN_IND_COLUMNS