eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.APPLY$_CDR_INFO

Object Details

Object Name:	APPLY$_CDR_INFO
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
APPLY$_CDR_INFO_UNQ1	NORMAL	UNIQUE	SYSTEM	LOCAL_TRANSACTION_ID SEQ# RBA INDEX#

Columns

Name	Datatype	Length
LOCAL_TRANSACTION_ID	VARCHAR2	(22)
SOURCE_TRANSACTION_ID	VARCHAR2	(128)
SOURCE_DATABASE	VARCHAR2	(128)
ERROR_NUMBER	NUMBER
ERROR_MESSAGE	VARCHAR2	(4000)
SOURCE_OBJECT_OWNER	VARCHAR2	(30)
SOURCE_OBJECT_NAME	VARCHAR2	(30)
DEST_OBJECT_OWNER	VARCHAR2	(30)
DEST_OBJECT_NAME	VARCHAR2	(30)
OPERATION	NUMBER
POSITION	RAW	(64)
SEQ#	NUMBER
RBA	NUMBER
INDEX#	NUMBER
RESOLUTION_STATUS	NUMBER
RESOLUTION_COLUMN	VARCHAR2	(4000)
RESOLUTION_METHOD	NUMBER
RESOLUTION_TIME	TIMESTAMP(6)	(11)
TABLE_SUCCESSFUL_CDR	NUMBER
TABLE_FAILED_CDR	NUMBER
ALL_SUCCESSFUL_CDR	NUMBER
ALL_FAILED_CDR	NUMBER
FLAGS	NUMBER
SPARE1	NUMBER
SPARE2	VARCHAR2	(4000)
SPARE3	TIMESTAMP(6)	(11)

Query Text

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


SELECT LOCAL_TRANSACTION_ID
,      SOURCE_TRANSACTION_ID
,      SOURCE_DATABASE
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      SOURCE_OBJECT_OWNER
,      SOURCE_OBJECT_NAME
,      DEST_OBJECT_OWNER
,      DEST_OBJECT_NAME
,      OPERATION
,      POSITION
,      SEQ#
,      RBA
,      INDEX#
,      RESOLUTION_STATUS
,      RESOLUTION_COLUMN
,      RESOLUTION_METHOD
,      RESOLUTION_TIME
,      TABLE_SUCCESSFUL_CDR
,      TABLE_FAILED_CDR
,      ALL_SUCCESSFUL_CDR
,      ALL_FAILED_CDR
,      FLAGS
,      SPARE1
,      SPARE2
,      SPARE3
FROM SYS.APPLY$_CDR_INFO;

Dependencies

[top of page]

SYS.APPLY$_CDR_INFO does not reference any database object

SYS.APPLY$_CDR_INFO is referenced by following:

SYS: DBMS_XSTREAM_GG_INTERNAL - show dependent code; _DBA_APPLY_CDR_INFO