Solved

EXPDP   QUERY option  -  Is there anyway to continue to the next line for a parameter

Posted on 2014-10-09
5
398 Views
Last Modified: 2014-10-09
I need to use expdp to export data using the query option.   The query I will be using is very long and I would like to be able to continue on the next line (actually multiple lines) within the parameter file.    This will make it much more readable.   Is there a way to do this?
0
Comment
Question by:ciphersol
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
Stampel earned 500 total points
ID: 40371091
You can have multiple lines as far as you follow this rule.

The preferred method of using QUERY parameter is in a parameter file is to put double quotes around the WHERE clause.

parameter file exp_emp.par contains,

TABLES:emp_salary
DUMPFILE=dump_dir
QUERY= emp_salary:"WHERE emp_id IN (SELECT id from emp
where join_date> to_date('2004-01-01','YYYY-MM-DD')
AND dept='SALSE')"
0
 

Author Closing Comment

by:ciphersol
ID: 40371239
Thank you.  That works.
0
 
LVL 7

Expert Comment

by:Stampel
ID: 40371409
I can not edit the post anymore.
Please add reference to  : http://shaharear.blogspot.fr/2008/09/using-query-parameter-in-expdpimpdp.html
My intend was not bad, i just prefer the solution inside the post than a link that can be broken in a few weeks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now