Hi,
I am trying to export a tables data with the following conditions but it fails. How to export the tables data with the below condition?? The datatype of the column is ID NOT NULL VARCHAR2(80)
exp test/test tables=EMP query=\"where id like '%00%'\" log=emp.log file=emp.dmp
Export: Release 11.2.0.1.0 - Production on Thu Nov 21 21:54:12 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table EMP
EXP-00056: ORACLE error 911 encountered
ORA-00911: invalid character
Export terminated successfully with warnings.
The same conditions the table has below mentioned number of records.
SQL> select count(*) from emp where id like '%00%';
COUNT(*)
----------
2701
Regards,
007