Oracle 视图 ALL_SYNC_CAPTURE_PREPARED_TABS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_SYNC_CAPTURE_PREPARED_TABS显示网络导出所有在预捕获模式将网络中传输的表和索引，用于创建复制版本。
用途： ALL_SYNC_CAPTURE_PREPARED_TABS视图用于监控Network Capture服务，检查哪些表被网络中传输、哪些表和索引准备了用于创建复制版本。
使用方法：
1.首先，我们可以使用之前网络捕获服务功能上一次传输的表和索引来查询ALL_SYNC_CAPTURE_PREPARED_TABS视图：
SELECT * FROM ALL_SYNC_CAPTURE_PREPARED_TABS;
2.可以根据表名而不是循环指针，检索Network Capture的表和索引：
SELECT * FROM ALL_SYNC_CAPTURE_PREPARED_TABS WHERE TABLE_NAME='[table_name]’;
官方英文解释
ALL_SYNC_CAPTURE_PREPARED_TABS displays information about the tables accessible to the current user that are prepared for synchronous capture instantiation.
Related View
DBA_SYNC_CAPTURE_PREPARED_TABS displays information about all tables in the database that are prepared for synchronous capture instantiation.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the table prepared for synchronous capture instantiation |
|
|
|
|
Name of the table prepared for synchronous capture instantiation |
|
|
|
|
SCN from which changes can be captured |
|
|
|
Time at which the table was ready to be instantiated |
See Also:
“DBA_SYNC_CAPTURE_PREPARED_TABS”
