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]

VIEW: SYS.CDB_CAPTURE_PREPARED_SCHEMAS

Object Details

Object Name:	CDB_CAPTURE_PREPARED_SCHEMAS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All schemas at the local database that are prepared for instantiation in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SCHEMA_NAME	VARCHAR2	(30)	Yes	Name of schema prepared for instantiation
TIMESTAMP	DATE			Time at which the schema was ready to be instantiated
SUPPLEMENTAL_LOG_DATA_PK	VARCHAR2	(8)		Status of schema-level PRIMARY KEY COLUMNS supplemental logging
SUPPLEMENTAL_LOG_DATA_UI	VARCHAR2	(8)		Status of schema-level UNIQUE INDEX COLUMNS supplemental logging
SUPPLEMENTAL_LOG_DATA_FK	VARCHAR2	(8)		Status of schema-level FOREIGN KEY COLUMNS supplemental logging
SUPPLEMENTAL_LOG_DATA_ALL	VARCHAR2	(8)		Status of schema-level ALL COLUMNS supplemental logging
CON_ID	NUMBER			container id

Query Text

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


SELECT SCHEMA_NAME
,      TIMESTAMP
,      SUPPLEMENTAL_LOG_DATA_PK
,      SUPPLEMENTAL_LOG_DATA_UI
,      SUPPLEMENTAL_LOG_DATA_FK
,      SUPPLEMENTAL_LOG_DATA_ALL
,      CON_ID
FROM SYS.CDB_CAPTURE_PREPARED_SCHEMAS;

Dependencies

[top of page]

SYS.CDB_CAPTURE_PREPARED_SCHEMAS does not reference any database object

SYS.CDB_CAPTURE_PREPARED_SCHEMAS is referenced by following:

PUBLIC: CDB_CAPTURE_PREPARED_SCHEMAS