Executing Basic Logdump Tasks
1-6 Oracle GoldenGate Reference for Logdump for Oracle GoldenGate
1.3.5 Filtering Based on a Table or Data File Name
To filter out everything except records containing a specific NonStop data file name,
enter the following command:
Logdump 60> FILTER INCLUDE FILENAME $volume.subvolume.file
To filter out everything except records containing a specific table name:
■ On a NonStop system:
Logdump 60> FILTER INCLUDE ANSINAME catalog.schema.table
■ On a Windows or UNIX system:
Logdump 60> FILTER INCLUDE FILENAME [container | catalog] schema.table
Now, when you use the
N
command, you will only see records that satisfy this filter.
Conversely, to filter out records containing a specific table or file name, but show
everything else, use the
EXCLUDE
option instead of
INCLUDE
.
1.3.6 Removing the Current Filter Criteria
To remove the current filter criteria, enter the following command:
Logdump 62> FILTER CLEAR
1.3.7 Filtering on Multiple Conditions
To filter on multiple conditions, enter one of the following commands:
■
Logdump 60> FILTER INCLUDE FILENAME $volume.subvolume...file..; FILTER
RECTYPE record_type; FILTER MATCH ALL
■
Logdump 60> FILTER INCLUDE ANSINAME catalog.schema.table; FILTER
RECTYPE record_type; FILTER MATCH ALL
■
Logdump 65> FILTER INCLUDE FILENAME schema.table; FILTER RECTYPE
record_type; FILTER MATCH ALL
Use
MATCH ANY
or
MATCH ALL
depending on whether you want the search to match any
or all of the filter conditions, respectively, when multiple conditions are specified. The
preceding example filters on a name and record type, typically an operation type such
as
INSERT
.
1.3.8 Count the Records in a Trail File
The following command shows a count summary followed by counts for each table or
data file:
Logdump 67> COUNT
1.3.9 Saving Records to a New Trail File
To save the whole file, enter the following command, where
file
is the name of the
new file:
Logdump 68> SAVE file
To save a subset of records, enter the following command:
剩余105页未读，继续阅读
wsnoly
- 粉丝: 0
- 资源: 2
我的内容管理
展开
最新资源
- zlib-1.2.12压缩包解析与技术要点
- 微信小程序滑动选项卡源码模版发布
- Unity虚拟人物唇同步插件Oculus Lipsync介绍
- Nginx 1.18.0版本WinSW自动安装与管理指南
- Java Swing和JDBC实现的ATM系统源码解析
- 掌握Spark Streaming与Maven集成的分布式大数据处理
- 深入学习推荐系统：教程、案例与项目实践
- Web开发者必备的取色工具软件介绍
- C语言实现李春葆数据结构实验程序
- 超市管理系统开发：asp+SQL Server 2005实战
- Redis伪集群搭建教程与实践
- 掌握网络活动细节：Wireshark v3.6.3网络嗅探工具详解
- 全面掌握美赛：建模、分析与编程实现教程
- Java图书馆系统完整项目源码及SQL文件解析
- PCtoLCD2002软件：高效图片和字符取模转换
- Java开发的体育赛事在线购票系统源码分析
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
