EXCLUDE/INCLUDE
来源:互联网 发布:单片机设计实例 编辑:程序博客网 时间:2024/05/22 05:12
一、用法
1、单值INCLUDE=TABLE:"= 'EMP'"
INCLUDE=TABLE:"= 'DEPT'"
2、多值
INCLUDE=TABLE:"IN ('EMP', 'DEPT')"
3、模糊匹配
INCLUDE=TABLE:"LIKE '%E%'"
INCLUDE=TABLE:"LIKE '%P%'"
二、引号转译
1、Windows:D:\> expdp system/manager DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log SCHEMAS=scott INCLUDE=TABLE:\"IN ('EMP', 'DEP')\"
2、Unix:
% expdp system/manager DIRECTORY=my_dir DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log SCHEMAS=scott INCLUDE=TABLE:\"IN \'EMP\',\'DEP\' \"三、内容
要确定可以指定的对象类型的名称与排除,包括,您可以运行以下查询:1、数据库级导入导出export/import:
SELECT named, object_path, comments FROM database_export_objects WHERE object_path NOT LIKE '%/%';2、表结构级导入导出 export/import:
SELECT named, object_path, comments FROM schema_export_objects WHERE object_path NOT LIKE '%/%';3、表级导入导出 export/import:
SELECT named, object_path, comments FROM table_export_objects WHERE object_path NOT LIKE '%/%';4、for TABLE dependent object types (10.2.0.x only):
SELECT named, object_path, comments FROM database_export_objects WHERE object_path LIKE 'TABLE/%';
阅读全文
0 0
- EXCLUDE/INCLUDE
- Robot: Include and Exclude Tags
- include-filter和exclude-filter
- 巧用IOS的begin、include、exclude
- expdp impdp中 exclude/include 的使用
- expdp impdp中 exclude/include 的使用
- context:exclude-filter 与 context:include-filter
- expdp impdp中 exclude/include 的使用 .
- expdp impdp中 exclude/include 的使用
- expdp impdp中 exclude/include 的使用
- expdp/impdp的EXCLUDE/INCLUDE用法
- expdp impdp中 exclude/include 的使用
- context:exclude-filter 与 context:include-filter
- expdp impdp中 exclude/include 的使用
- include-filter和exclude-filter的区别
- expdp impdp中 exclude/include 的使用
- include-filter和exclude-filter的区别
- expdp impdp中 exclude/include 的使用
- 并发库之CountDownLatch
- 1060. Are They Equal (25)
- recyclerView和retrofit的简单使用
- Ueditor编辑器图片上传自定义配置
- javascript--BOM概念
- EXCLUDE/INCLUDE
- python基础语法
- This page contains the following errors: error on line 1 at column 1: Extra content at the end of t
- java的HashMap类提供的方法
- ffmpeg音频处理——pcm格式与resample(重采样)
- CSS初始化样式
- blend画图技巧
- 并发库之同步屏障
- RecyclerView