Database Administration (MOSC)

MOSC Banner

exp: no rows exported

edited Mar 8, 2016 4:05AM in Database Administration (MOSC) 7 commentsAnswered

  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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center