高分求unix下expdp导出exclude的正确语法!!!
oracle文档上公布的:EXCLUDE=OBJECT_TYPE[:NAME_CLAUSE][,....]
但实际操作中直接套用exclude=TABLE:(table1,table2)不行
exclude=TABLE:"in('table1','table2')" 也行不通
加入各种/转义字符也不行,求正确语法!
oracle文档上公布的:EXCLUDE=OBJECT_TYPE[:NAME_CLAUSE][,....]
但实际操作中直接套用exclude=TABLE:(table1,table2)不行
exclude=TABLE:"in('table1','table2')" 也行不通
加入各种/转义字符也不行,求正确语法!
解决方案 »
- oracle 10g怎么安装成中文的?
- 说说 同义词
- 什么是Oracle的闪回特性,Oracle是怎样做到“时空穿越”回到过去,查询到已经被修改了的“老”数据的
- 表空间和表都可以自动扩展的,但空间不够时,要出错
- 在oracle数据库中,保存图片的问题!
- 在存储过程中用一个变量存储where语句(AA),这个变量如何与select * from 表1 ||AA
- 请问一下 ORA-02042:这个问题
- 机器p1安装了oracle,机器p2安装了oracle,我想用p1的机器,连接p2的oracle
- 协议问题
- 我的客户端是ora9i,服务器是ora817,备份时出错!!
- 关于Oracle连接的问题
- sqlldr问题
expdb还不熟悉,楼主可以试下用plsql的export功能选项吗?
要用这种语法
$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 8 10:04:51 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdba
Connected.
SQL> create directiory tmp as '/tmp/';
create directiory tmp as '/tmp/'
*
ERROR at line 1:
ORA-00901: invalid CREATE command
SQL> create directory tmp as '/tmp/';Directory created.SQL> GRANT READ,WRITE ON DIRECTORY tmp to hnky;
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options$ expdp hnky/hnky dumpfile=exp_dir:tmp EXCLUDE=TABLE:"IN ('T1','T2')"Export: Release 10.2.0.1.0 - 64bit Production on Wednesday, 08 April, 2009 10:17:49Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
.....
dumpfile=myfile.dmp
logfile=myfile.log
exclude=TABLE:"IN('TABLE1','TABLE2')"然后导出
expdp user/passwd parfile=mypar.par
expdp system directory=dump_dir schemas=scott dumpfile=expdb.dmp exclude=table:"in('scott.emp','scott.dept')";LRM-00116: ')'后跟'scott.dept'时出现语法错误
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
.....再往下就是连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORA-39071: EXCLUDE 值的格式错误。
ORA-00920: 无效的关系运算符
语法错误exclude=table:"in ('t1','t2')"试过是可以的