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
becuase you asked to export the schema, not a table!
funny that when you specify the exact tables it only does the ones you ask for
Thanks, I was under the impression that the SCHEMA= clause meant backup
Since you cannot recover your database from an expdp dump file that means expdp is not a backup tool, just a useful tool to copy data, ddl and code.
Originally Posted by
Pablo (Paul) Berzukov
Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width