exp: no rows exported
Hello,
I am exporting the data using export utility in 11g 11.1.0.7 with query parameter. However, it is not exporting any rows, though the rows are there in database. The command and output I am using are as follows:
exp user@tns file=test.dmp tables='"""TestTable"""' query= \"where \'"TestId"\' \= \'219\'\"
Export: Release 11.1.0.7.0 - Production on Tue Mar 1 00:13:01 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in AR8MSWIN1256 character set and UTF8 NCHAR character set