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

TABLE: SYS.SYNCREF$_STEP_STATUS

Object Details
Object Name: SYNCREF$_STEP_STATUS
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
SYS_IL0000624858C00009$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000624858C00010$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Yes
OPERATION NUMBER
Yes
STEP_SEQ_NUM NUMBER
Yes
STMT_GRP_TYPE NUMBER
Yes
STMT_TYPE NUMBER
Yes
STMT_STEP NUMBER
Yes
OBJ# NUMBER
Yes
AUX_OBJ# NUMBER

STATEMENT CLOB (4000)
UNDO_STATEMENT CLOB (4000)
STATUS NUMBER
Yes
OWNER VARCHAR2 (30)
OBJ_NAME VARCHAR2 (30)
AUX_OBJ_NAME VARCHAR2 (30)
Query Text

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


SELECT GROUP_ID
,      OPERATION
,      STEP_SEQ_NUM
,      STMT_GRP_TYPE
,      STMT_TYPE
,      STMT_STEP
,      OBJ#
,      AUX_OBJ#
,      STATEMENT
,      UNDO_STATEMENT
,      STATUS
,      OWNER
,      OBJ_NAME
,      AUX_OBJ_NAME
FROM SYS.SYNCREF$_STEP_STATUS;

Dependencies

[top of page]

SYS.SYNCREF$_STEP_STATUS does not reference any database object

SYS.SYNCREF$_STEP_STATUS is not referenced by any database object