Oracle 视图 DBA_SR_PARTN_OPS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_SR_PARTN_OPS是Data Dictionary视图之一，用于描述存储网络数据宽带管理器（Storage Repartitioner）管理的分卷操作信息。
该视图的记录表示以往操作的基本效果，而且指示任何存储分卷操作的当前策略。
使用DBA_SR_PARTN_OPS视图可以查看Storage Repartitioner正在进行的操作，以及以前完成的操作的分析结果。此外，还可以启用或禁用某个操作，查看操作类型（create，drop），以及其它有用信息。
官方英文解释
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:
-
“USER_SR_PARTN_OPS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_SYNC_REFRESHpackage
