data pump with query clause
I have to tables created under user pbh (abc, xyz)
When I issue the following command (see below) both tables get exported.
What in the command below is making table 'abc' export? I would suspect
that only data from 'xyz' would have been exported?
Note: If I specify tables=xyz at the end of the command that seems to
only export table xyz only.
I am using Oracle 10.2.0.1.0
expdp pbh/pbh directory=data_pump_directory dumpfile=query.dmp logfile=table.log QUERY=xyz:'"where x>=1234"'
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "PBH"."XYZ" 377.2 KB 31744 rows
. . exported "PBH"."ABC" 5.406 KB 11 rows
Click Here to Expand Forum to Full Width