Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_SR_STLOG_EXCEPTIONS

DBA_SR_STLOG_EXCEPTIONS provides information on the exceptions in the staging logs for the tables processed by DBMS_SYNC_REFRESH.PREPARE_STAGING_LOG.

Related View

USER_SR_STLOG_EXCEPTIONS provides information on the exceptions in the staging logs for the tables belonging to the current user processed by DBMS_SYNC_REFRESH.PREPARE_STAGING_LOG. Its columns are the same as those in DBA_SR_STLOG_EXCEPTIONS.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the base table registered for synchronous refresh
TABLE_NAME VARCHAR2(128) NOT NULL Name of the base table registered for synchronous refresh
STAGING_LOG_NAME VARCHAR2(128) NOT NULL Name of the staging log for tables. This column has a value of NULL for materialized views.
BAD_ROWID ROWID NOT NULL Row ID of the staging log row causing the exception for the synchronous refresh
ERROR_NUMBER NUMBER   Error number of the exception for the synchronous refresh
ERROR_MESSAGE VARCHAR2(4000)   Error message associated with the ERROR_NUMBER for the synchronous refresh

See Also: