DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009

    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

    expdp pbh/pbh directory=data_pump_directory dumpfile=query.dmp logfile=table.log QUERY=xyz:'"where x>=1234"'

    . . exported "PBH"."XYZ" 377.2 KB 31744 rows
    . . exported "PBH"."ABC" 5.406 KB 11 rows

  2. #2
    Join Date
    Sep 2002
    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

  3. #3
    Join Date
    Feb 2009
    Thanks, I was under the impression that the SCHEMA= clause meant backup
    the schema.

  4. #4
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    Quote Originally Posted by PaulH View Post
    I was under the impression that the SCHEMA= clause meant backup the schema.
    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.
    Pablo (Paul) Berzukov

    Author of 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.