Oracle 视图 ALL_CAPTURE_PREPARED_TABLES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_CAPTURE_PREPARED_TABLES提供了统一的方法来获得正在进行的流量捕获会话中正在关联的数据表的信息，该视图将返回包含连接被捕获的会话以及正在关联的数据表的信息。
使用该视图的方法为：
1.先在相关数据库实例中创建一个新的流量捕获会话：
CREATE CAPTURE|CAPTURE ALL ON TABLE table_name[,table_name]…;
2.然后使用视图来查询该捕获会话中正在关联的表：
SELECT * FROM ALL_CAPTURES_PREPARED_TABLES;
3.可以参数过滤该捕获特定表：
SELECT * FROM ALL_CAPTURES_PREPARED_TABLES WHERE CAPTURE_NAME=’your_capture_name’;
官方英文解释
ALL_CAPTURE_PREPARED_TABLES displays information about the tables prepared for instantiation that are accessible to the current user at the local database.
Related View
DBA_CAPTURE_PREPARED_TABLES displays information about all tables prepared for instantiation at the local database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the table that is ready to be instantiated |
|
|
|
|
Name of the table that is ready to be instantiated |
|
|
|
|
Smallest system change number (SCN) for which the table can be instantiated |
|
|
|
Date and time at which the table was ready to be instantiated |
|
|
|
|
Status of table-level PRIMARY KEY COLUMNS supplemental logging:
|
|
|
|
|
Status of table-level UNIQUE INDEX COLUMNS supplemental logging:
|
|
|
|
|
Status of table-level FOREIGN KEY COLUMNS supplemental logging:
|
|
|
|
|
Status of table-level ALL COLUMNS supplemental logging:
|
See Also:
“DBA_CAPTURE_PREPARED_TABLES”
