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_PARTN_OPS

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 VARCHAR2(128) NOT NULL Owner of the base table registered for synchronous refresh
TABLE_NAME VARCHAR2(128) NOT NULL Name of the table
PARTITION_OP VARCHAR2(30) NOT NULL Type of partition operation:
  • DROP

  • EXCHANGE

  • TRUNCATE

PARTITION_NAME VARCHAR2(30) NOT NULL Name of the partition to be changed
OUTSIDE_TABLE_SCHEMA VARCHAR2(30)   Schema in which the outside table (for EXCHANGE PARTITION) was created
OUTSIDE_TABLE_NAME VARCHAR2(30)   Name of the outside table (for EXCHANGE PARTITION)

See Also: