例如,以下是一个可能导致 ORA-39035 错误的 expdp 命令示例: bash expdp user/password DIRECTORY=dir_name DUMPFILE=exp.dmp SCHEMAS=schema_name QUERY=schema_name.table_name:"WHERE column_name = 'value1'" FILTER=schema_name.table_name:"WHERE column_name2 = 'value2'" 在这个示例中,同时使用了 ...
oracle使用expdp导出数据的时候提示 错误参数: 1query="where rownum<10001 order by JLGXSJ desc" 正确参数: 1query='"where rownum<10001 order by JLGXSJ desc"' 错误原因:少了单引号。 ---正 文已结束, 感谢您的阅读 (折雨的天空)--- 》
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production ORA-39001: invalid argument value ORA-39035: Data filter SUBQUERY has already been specified. Solution [oracle@testdb ~]$ expdp hari/hari@pdb1 tables=emp directory=TEST_DIR query=“‘where salary > 5000‘”...
Same happens for include and exclude parameters as well without specifying object name [oracle@orcl19x ~]$ expdp \'/ as sysdba\' directory=exp dumpfile=tabx.dmp logfile=tabx.log exclude=index,constraint,statistics Export: Release 12.1.0.2.0 - Production on Fri Aug 13 18...