5.388 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 of the base table registered for synchronous refresh |
|
|
|
Name of the base table registered for synchronous refresh |
|
|
|
Name of the staging log for tables. This column has a value of NULL for materialized views. |
|
|
|
Row ID of the staging log row causing the exception for the synchronous refresh |
|
|
|
Error number of the exception for the synchronous refresh |
|
|
|
Error message associated with the |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_SYNC_REFRESH
package