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


TABLE: SYS.TRIGGERDEP$

Object Details
Object Name: TRIGGERDEP$
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
TRIGGERDEPIND$ NORMAL NONUNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER

P_TRGOWNER VARCHAR2 (128)
P_TRGNAME VARCHAR2 (128)
FLAG NUMBER
Yes
SPARE1 NUMBER

SPARE2 NUMBER

Query Text

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


SELECT OBJ#
,      P_TRGOWNER
,      P_TRGNAME
,      FLAG
,      SPARE1
,      SPARE2
FROM SYS.TRIGGERDEP$;

Dependencies

[top of page]

SYS.TRIGGERDEP$ does not reference any database object

SYS.TRIGGERDEP$ is referenced by following:

SchemaSYS
PL/SQL PackageDBMS_REDEFINITION_INTERNAL - show dependent code
ViewKU$_TRIGGERDEP_VIEW
View_DBA_TRIGGER_ORDERING