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

VIEW: SYS.CDB_SR_OBJ_ALL

Object Details
Object Name: CDB_SR_OBJ_ALL
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All synchronous refresh objects in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the synchronous refresh object
NAME VARCHAR2 (128) Yes Name of the synchronous refresh object
TYPE VARCHAR2 (5)
Type of synchronous refresh object in the database: TABLE, MVIEW
GROUP_ID NUMBER
Yes Group ID of the synchronous refresh object
CURRENT_GROUP VARCHAR2 (1)
Indicates whether the synchronous refresh group is in the current group: Y - YES, N - NO
STAGING_LOG_NAME VARCHAR2 (128)
Staging log name of the synchronous refresh object table
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      NAME
,      TYPE
,      GROUP_ID
,      CURRENT_GROUP
,      STAGING_LOG_NAME
,      CON_ID
FROM SYS.CDB_SR_OBJ_ALL;

Dependencies

[top of page]

SYS.CDB_SR_OBJ_ALL does not reference any database object

SYS.CDB_SR_OBJ_ALL is referenced by following:

SchemaPUBLIC
SynonymCDB_SR_OBJ_ALL