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

TABLE: SYS.CHNF$_QUERY_DELTAS

Object Details
Object Name: CHNF$_QUERY_DELTAS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Temporary Table Details

SYS.CHNF$_QUERY_DELTAS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
XID RAW (8)
COL_OPERATION NUMBER

QUERYID NUMBER

TRIGOBJ NUMBER

CHGROWID VARCHAR2 (2000)
CHGROWOP NUMBER

ROWID1 VARCHAR2 (2000)
ROWID2 VARCHAR2 (2000)
ROWID3 VARCHAR2 (2000)
ROWID4 VARCHAR2 (2000)
ROWID5 VARCHAR2 (2000)
COL0_0 NUMBER

COL0_1 NUMBER

COL0_2 NUMBER

COL0_3 NUMBER

COL0_4 NUMBER

COL0_5 NUMBER

COL0_6 NUMBER

COL0_7 NUMBER

COL0_8 NUMBER

COL0_9 NUMBER

COL0_10 NUMBER

COL1_0 VARCHAR2 (4000)
COL1_1 VARCHAR2 (4000)
COL1_2 VARCHAR2 (4000)
COL1_3 VARCHAR2 (4000)
COL1_4 VARCHAR2 (4000)
COL1_5 VARCHAR2 (4000)
COL1_6 VARCHAR2 (4000)
COL1_7 VARCHAR2 (4000)
COL1_8 VARCHAR2 (4000)
COL1_9 VARCHAR2 (4000)
COL1_10 VARCHAR2 (4000)
COL2_0 RAW (512)
COL2_1 RAW (512)
COL2_2 RAW (512)
COL2_3 RAW (512)
COL2_4 RAW (512)
COL2_5 RAW (512)
COL2_6 RAW (512)
COL2_7 RAW (512)
COL2_8 RAW (512)
COL2_9 RAW (512)
COL2_10 RAW (512)
COL3_0 DATE

COL3_1 DATE

COL3_2 DATE

COL3_3 DATE

COL3_4 DATE

COL3_5 DATE

COL3_6 DATE

COL3_7 DATE

COL3_8 DATE

COL3_9 DATE

COL3_10 DATE

SRCFROPOS NUMBER

Query Text

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


SELECT XID
,      COL_OPERATION
,      QUERYID
,      TRIGOBJ
,      CHGROWID
,      CHGROWOP
,      ROWID1
,      ROWID2
,      ROWID3
,      ROWID4
,      ROWID5
,      COL0_0
,      COL0_1
,      COL0_2
,      COL0_3
,      COL0_4
,      COL0_5
,      COL0_6
,      COL0_7
,      COL0_8
,      COL0_9
,      COL0_10
,      COL1_0
,      COL1_1
,      COL1_2
,      COL1_3
,      COL1_4
,      COL1_5
,      COL1_6
,      COL1_7
,      COL1_8
,      COL1_9
,      COL1_10
,      COL2_0
,      COL2_1
,      COL2_2
,      COL2_3
,      COL2_4
,      COL2_5
,      COL2_6
,      COL2_7
,      COL2_8
,      COL2_9
,      COL2_10
,      COL3_0
,      COL3_1
,      COL3_2
,      COL3_3
,      COL3_4
,      COL3_5
,      COL3_6
,      COL3_7
,      COL3_8
,      COL3_9
,      COL3_10
,      SRCFROPOS
FROM SYS.CHNF$_QUERY_DELTAS;

Dependencies

[top of page]

SYS.CHNF$_QUERY_DELTAS does not reference any database object

SYS.CHNF$_QUERY_DELTAS is not referenced by any database object