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

TABLE: SYSTEM.MVIEW$_ADV_FJG

Object Details
Object Name: MVIEW$_ADV_FJG
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Representation for query join sub-graph not in AJG

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MVIEW$_ADV_FJG_PK
  1. ColumnFJGID#
Indexes
Index Type Uniqueness Tablespace Column
MVIEW$_ADV_FJG_PK NORMAL UNIQUE TablespaceSYSTEM ColumnFJGID#
Foreign Keys
Table
Foreign Table Foreign Key Column
MVIEW$_ADV_FJG MVIEW$_ADV_FJG_FK TableMVIEW$_ADV_AJG MVIEW$_ADV_FJG AJGID#
TableMVIEW$_ADV_GC MVIEW$_ADV_GC_FK MVIEW$_ADV_FJG MVIEW$_ADV_GC FJGID#
Columns
Name Datatype Length Mandatory Comments
FJGID# NUMBER
Yes
AJGID# NUMBER
Yes
FJGDESLEN NUMBER
Yes
FJGDES LONG RAW (0) Yes
HASHVALUE NUMBER
Yes
FREQUENCY NUMBER

Query Text

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


SELECT FJGID#
,      AJGID#
,      FJGDESLEN
,      FJGDES
,      HASHVALUE
,      FREQUENCY
FROM SYSTEM.MVIEW$_ADV_FJG;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_FJG does not reference any database object

SYSTEM.MVIEW$_ADV_FJG is referenced by following:

SchemaSYS
Package BodyPRVT_WORKLOAD - show dependent code