1 person found this helpful
Do the following
expdp user/pass query=\"WHERE rownum \<1001\" schemas=a,b,c
I've got \ escape characters for linux in the command above - it might be better to use a parfile.
Thank you Richard,
content of parfile is
dumpfile=1000rowss.dmp logfile=1000r2.log directory=backup schemas=bipub query=\"where rownum < 1001\"
i have executed
C:\>expdp eraj@txdata parfile=1000rows.txt
Export: Release 188.8.131.52.0 - Production on Thu Aug 21 03:58:05 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 - 64bit
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ORA-39001: invalid argument value
ORA-39035: Data filter SUBQUERY has already been specified.
please help me with this
Thanks in advance
you don't need any of the escpae characters in the parfile so it should look like this:
dumpfile=1000rowss.dmp logfile=1000r2.log directory=backup schemas=bipub query="where rownum < 1001"
Thank you richard. its working
For testing purpose you can use the "sample" parameter of expdp too.
expdp dumpfile=5percentsample.dmp logfile=5percentsample.log directory=backup schemas=bipub sample=5
This will export 5% of each table. This is not your exact requirement but this is another solution ( and it does not require escape chars of parfile ).
The expdp command may technically work, but is the target database instance usable from an application perspective ? How are referential constraints being affected if you are only exporting 1000 rows from each table ?