Oracle 排除表导出

1，创建一个dir目录testDir用来存储导出文件

Win:  直接创建c:testDir

Linux: mkdir /testDir

            chmod 777 /testDir

2，创建一个一个Directory

登录ORACLE

Win : create or replace directory test_dir as "c:testDir" ;

Linux:create or replace directory test_dir as " /testDir" ;

给权限

grant read,write on directory to USERNAME ;

退出ORACLE

3，执行导出语句

Win: expdp USERNAME /PWD@orcl schemas=scott exclude:TABLES:\"= 'TABLE_NAME'\" directory=test_dir dumpfile=scott.dmp logfile=scott.log

Linux: expdp USERNAME /PWD@orcl schemas=scott exclude:TABLES:\"= \'TABLE_NAME\'\"  dumpfile=test_dir:scott.dmp logfile=test_dir:scott.log