Home » RDBMS Server » Server Utilities » Multiple queries with expdp
Multiple queries with expdp [message #252607] Thu, 19 July 2007 06:51 Go to next message
aajk
Messages: 7
Registered: July 2007
Location: India
Junior Member
Hi all,

Is there any facility to give multiple queries in expdp


Actually I want to export more than one table with different queries corresponding to each table


Regards
Arjun
Re: Multiple queries with expdp [message #252610 is a reply to message #252607] Thu, 19 July 2007 06:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why not different expdb executions?
You could run them in parallel.

Regards
Michel
Re: Multiple queries with expdp [message #252611 is a reply to message #252610] Thu, 19 July 2007 06:59 Go to previous messageGo to next message
aajk
Messages: 7
Registered: July 2007
Location: India
Junior Member
Hi Michel,

I was searching for a way to create single dumpfile for different tables

Regards,
Arjun
Re: Multiple queries with expdp [message #252620 is a reply to message #252611] Thu, 19 July 2007 07:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Utilities
Part I Oracle Data Pump
Chapter 2 Data Pump Export
Section Parameters Available in Export's Command-Line Mode
Subsection QUERY
Quote:
QUERY = [schema.][table_name:] query_clause

You can have multiple QUERY options.

Regards
Michel
Re: Multiple queries with expdp [message #252627 is a reply to message #252620] Thu, 19 July 2007 08:09 Go to previous messageGo to next message
aajk
Messages: 7
Registered: July 2007
Location: India
Junior Member
Hi Michel,

i tried what you suggested

Trail1:-
exp 'sys/alm@alm10g as sydba' directory=export dumpfile=testing1.dmp
tables=almoib.<table>
query=almoib.<table>:'where lgm_load_date=''31-jul-06'''

Trial2:-
exp 'sys/alm@alm10g as sydba'directory=export
dumpfile=testing1.dmp
tables=almoib.<table>
query='where lgm_load_date=''31-jul-06'''


Trial 2 executed fine while Trail1(which will solve my problem) gave the following error

:unknown parameter name lgm_load_date

Can u help on this...any quotation marks problem!!! but everything is same as in the Trail2...

I also tried with double quotes as shown in the example you attached....but with that both trials are not working....


Regards,
Arjun

[Updated on: Thu, 19 July 2007 08:14]

Report message to a moderator

Re: Multiple queries with expdp [message #252631 is a reply to message #252627] Thu, 19 July 2007 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is impossible to see if you used simple or double quotes if you don't format your post.
Moreover, if it is just a syntax problem then try several ones you finally got the correct one.

Also maybe the documentation has examples. Did you check it?

Regards
Michel
Re: Multiple queries with expdp [message #252638 is a reply to message #252631] Thu, 19 July 2007 08:49 Go to previous message
aajk
Messages: 7
Registered: July 2007
Location: India
Junior Member
Hi Michel,

Thank you for your suggestions....Now it is working fine

I gave the following command

expdp 'sys/alm@alm10g as sysdba'
directory=export dumpfile=testing5.dmp
tables=almoib.<table1>,almoib.<table2>
query='almoib.<table1>:where lgm_load_date=''31-jul-06''','almoib.<table2>:where lgcu_load_date=''31-jul-06'''

Problem was that inside query tables were not in the quotes


Thank you again for your help

Regards,
Arjun Jkoshi
Previous Topic: SQL Loader Control File - User Name / User ID : How to get it
Next Topic: way to load excel sheet having colums with comments on them
Goto Forum:
  


Current Time: Mon Dec 05 21:05:40 CST 2016

Total time taken to generate the page: 0.20912 seconds