Oracle 视图 DBA_SR_STLOG_EXCEPTIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_SR_STLOG_EXCEPTIONS存储有关Oracle Streams异常的信息。它是数据库中归档的状态信息的集合，主要在诊断Streams的容错性和恢复性方面起到作用。该视图可用于检查从流源到流目标的消息是否完好。它还存储允许用户进行调整以使Streams正常工作的信息，如重放消息、建立流、删除流等等。
使用DBA_SR_STLOG_EXCEPTIONS视图可以完成以下目标：
1、检查Streams可恢复的异常。
2、查看需要重发的消息列表。
3、检查错误消息的源和目标实例。
4、显示发生错误的事件类型、表空间及其他内容。
5、检查正确处理消息的源和目标实例。
6、显示发生错误的时间等。
官方英文解释
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:
-
“USER_SR_STLOG_EXCEPTIONS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_SYNC_REFRESHpackage
