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.DBA_CAPTURE_PREPARED_SCHEMAS

Object Details

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

All schemas at the local database that are prepared for instantiation

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SCHEMA_NAME	VARCHAR2	(128)	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

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
FROM SYS.DBA_CAPTURE_PREPARED_SCHEMAS;

Dependencies

[top of page]

SYS.DBA_CAPTURE_PREPARED_SCHEMAS references the following:

SYS: STREAMS$_PREPARE_DDL; USER$

SYS.DBA_CAPTURE_PREPARED_SCHEMAS is referenced by following:

PUBLIC: DBA_CAPTURE_PREPARED_SCHEMAS
SYS: ALL_CAPTURE_PREPARED_SCHEMAS; DBMS_LOGREP_EXP - show dependent code; DBMS_STREAMS_ADM_IVK - show dependent code