DBA_SR_PARTN

5.387 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(128)`	`NOT NULL`	Type of partition operation: `DROP` `EXCHANGE` `TRUNCATE`
`PARTITION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the partition to be changed
`OUTSIDE_TABLE_SCHEMA`	`VARCHAR2(128)`		Schema in which the outside table (for `EXCHANGE PARTITION`) was created
`OUTSIDE_TABLE_NAME`	`VARCHAR2(128)`		Name of the outside table (for `EXCHANGE PARTITION`)