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

TABLE: SYSTEM.DEF$_CALLDEST

Object Details
Object Name: DEF$_CALLDEST
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Information about call destinations for D-type and error transactions

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: DEF$_CALLDEST_PRIMARY
  1. ColumnENQ_TID
  2. ColumnDBLINK
  3. ColumnSTEP_NO
Indexes
Index Type Uniqueness Tablespace Column
DEF$_CALLDEST_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnENQ_TID
ColumnDBLINK
ColumnSTEP_NO
DEF$_CALLDEST_N2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnDBLINK
ColumnCATCHUP
Foreign Keys
Table
Foreign Table Foreign Key Column
DEF$_CALLDEST DEF$_CALL_DESTINATION TableDEF$_DESTINATION DEF$_CALLDEST DBLINK
DEF$_CALLDEST CATCHUP
Columns
Name Datatype Length Mandatory Comments
ENQ_TID VARCHAR2 (22) Yes Transaction ID
STEP_NO NUMBER
Yes Unique ID of call within transaction
DBLINK VARCHAR2 (128) Yes The destination database
SCHEMA_NAME VARCHAR2 (128)
The schema of the deferred remote procedure call
PACKAGE_NAME VARCHAR2 (128)
The package of the deferred remote procedure call
CATCHUP RAW (16)
Dummy column for foreign key
Query Text

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


SELECT ENQ_TID
,      STEP_NO
,      DBLINK
,      SCHEMA_NAME
,      PACKAGE_NAME
,      CATCHUP
FROM SYSTEM.DEF$_CALLDEST;

Dependencies

[top of page]

SYSTEM.DEF$_CALLDEST does not reference any database object

SYSTEM.DEF$_CALLDEST is referenced by following:

SchemaSYS
Package BodyDBMS_DEFER_INTERNAL_SYS - show dependent code
Package BodyDBMS_DEFER_QUERY_UTL - show dependent code
Package BodyDBMS_DEFER_SYS_DEFINER - show dependent code
Package BodyDBMS_DEFER_SYS_PART1 - show dependent code
SynonymDEF$_CALLDEST
ViewDEFCALLDEST
View_DEFTRANDEST