Oracle 视图 ALL_CAPTURE_PREPARED_SCHEMAS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_CAPTURE_PREPARED_SCHEMAS视图显示了系统权限允许的捕获准备用户对象，以及它们当前存在的位置。该视图是在采用跨多个数据库的视图中使用Dataguard。
用法：
1. 查看可以捕获预备的用户：
SELECT * FROM all_capture_prepared_schemas;
2. 查看指定的捕获准备的用户的位置：
SELECT * FROM all_capture_prepared_schemas WHERE object_user = ‘USERNAME’;
官方英文解释
ALL_CAPTURE_PREPARED_SCHEMAS displays information about the schemas prepared for instantiation that are accessible to the current user at the local database.
Related View
DBA_CAPTURE_PREPARED_SCHEMAS displays information about all schemas prepared for instantiation at the local database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the schema that is ready to be instantiated |
|
|
|
Date and time at which the schema was ready to be instantiated |
|
|
|
|
Status of schema-level PRIMARY KEY COLUMNS supplemental logging:
|
|
|
|
|
Status of schema-level UNIQUE INDEX COLUMNS supplemental logging:
|
|
|
|
|
Status of schema-level FOREIGN KEY COLUMNS supplemental logging:
|
|
|
|
|
Status of schema-level ALL COLUMNS supplemental logging:
|
See Also:
“DBA_CAPTURE_PREPARED_SCHEMAS”
