DBA_SR_PARTN_OPS
provides information on the partition operations registered on the base tables of the materialized views registered for synchronous refresh. These rows last only as long as the registrations are active; that is, they disappear after EXECUTE_REFRESH
or ABORT_REFRESH
of the base table by the DBMS_SYNC_REFRESH
package.
Related View
USER_SR_PARTN_OPS
provides information on the partition operations registered on the base tables of the materialized views registered for synchronous refresh belonging to the current user. Its columns are the same as those in DBA_SR_PARTN_OPS
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the base table registered for synchronous refresh |
|
|
|
Name of the table |
|
|
|
Type of partition operation:
|
|
|
|
Name of the partition to be changed |
|
|
Schema in which the outside table (for |
|
|
|
Name of the outside table (for |
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_SYNC_REFRESH
package