Document Type | Technical Information
Category | Migration
Applicable Product Versions | 5SP1FS01, 5SP1FS02, 5SP1FS03, 5SP1FS04, 5SP1FS06, 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS
Document Number | TMITI009
Overview
TIBERO DB includes an exclude option to omit specific tables.
This guide explains how to use the exclude command option.
Method
Exclude Multiple Specific Tables Using the exclude Option
- Export Command Format
exclude=schema:\"=\'User1\'/table:LIKE\'Table1%\'\" exclude=schema:\"=\'User2\'/table:LIKE\'Table2%\'\" exclude=schema:\"=\'User3_1\'/table:LIKE\'Table3%\'\"
- Export Command Example
tbexport username=sys password=tibero port=PortNumber ip=ip sid=tibero6_gis exclude=schema:\"=\'KA1\'/table:LIKE\'KA1%\'\" exclude=schema:\"=\'KA2\'/table:LIKE\'KA3%\'\" log=/sdiske/ps1/mjh/tibero6_gis/export/gis3.log file=/sdiske/ps1/mjh/tibero6_gis/export/gis3.dmp script=y full=y