You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for USER_SR_OBJ_STATUS


1 to 9 of 9 results.


Database Reference, 12c Release 1 (12.1)

USER_SR_OBJ_STATUS

6.554 USER_SR_OBJ_STATUSUSER_SR_OBJ_STATUS provides information on the status of objects registered for synchronous refresh

Database Data Warehousing Guide, 12c Release 1 (12.1)

Synchronous Refresh

Overview of the Status of Refresh OperationsUSER_SR_OBJ_STATUS catalog views contain all the information on the status of these refresh operations for … . These are explained in detail later. The group is identified by its group ID. The USER_SR_OBJ_STATUS

Database Data Warehousing Guide, 12c Release 1 (12.1)

Synchronous Refresh

Examples of Common Actions with Synchronous Refresh GroupsUSER_SR_OBJ_STATUS WHERE GROUP_ID = DBMS_SYNC_REFRESH.GET_GROUP_ID('MV1') ORDER BY TYPE, NAME; Example … FROM USER_SR_OBJ_STATUS WHERE GROUP_ID = DBMS_SYNC_REFRESH.GET_GROUP_ID('MV1') ORDER BY TYPE, NAME

Database Reference, 12c Release 1 (12.1)

DBA_SR_OBJ_STATUS

5.343 DBA_SR_OBJ_STATUSDBA_SR_OBJ_STATUS_ALL view. Related View USER_SR_OBJ_STATUS provides information on the status of objects registered … time of the synchronous refresh object See Also: \" USER_SR_OBJ_STATUS \"

Database Data Warehousing Guide, 12c Release 1 (12.1)

Synchronous Refresh

How EXECUTE_REFRESH Sets the Status Fields During Synchronous RefreshUSER_SR_OBJ_STATUS view: The status of an object is set to COMPLETE if the changes were applied to it

Database Data Warehousing Guide, 12c Release 1 (12.1)

Synchronous Refresh

Examples of Executing Synchronous Refresh Using EXECUTE_REFRESH, TYPE, STATUS FROM USER_SR_OBJ_STATUS WHERE GROUP_ID = DBMS_SYNC_REFRESH.GET_GROUP_ID('MV1') ORDER BY

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsUSER_SR_OBJ_STATUS 6.555 USER_SR_OBJ_STATUS_ALL 6.556 USER_SR_PARTN_OPS 6.557 USER_SR_STLOG_EXCEPTIONS 6.558

Database Reference, 12c Release 1 (12.1)

Changes in This Release for Oracle Database Reference

New FeaturesUSER_SR_OBJ_STATUS DBA_SR_OBJ_STATUS_ALL and USER_SR_OBJ_STATUS_ALL DBA_SR_PARTN_OPS and USER_SR_PARTN_OPS

Database Error Messages, 12c Release 1 (12.1)

QSM-00501 to QSM-03287

QSM-03280: One or more materialized views failed to refresh successfully.this case. Action: To find the materialized views which failed, query the USER_SR_OBJ_STATUS catalog