OraFAQ Forum: Server Utilities » Multiple queries with expdp

Home » RDBMS Server » Server Utilities » Multiple queries with expdp

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multiple queries with expdp [message #252607]

Thu, 19 July 2007 06:51

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

Report message to a moderator

Re: Multiple queries with expdp [message #252610 is a reply to message #252607]

Thu, 19 July 2007 06:55

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why not different expdb executions?
You could run them in parallel.

Regards
Michel

Report message to a moderator

Re: Multiple queries with expdp [message #252611 is a reply to message #252610]

Thu, 19 July 2007 06:59

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

Report message to a moderator

Re: Multiple queries with expdp [message #252620 is a reply to message #252611]

Thu, 19 July 2007 07:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Multiple queries with expdp [message #252627 is a reply to message #252620]

Thu, 19 July 2007 08:09

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Multiple queries with expdp [message #252638 is a reply to message #252631]

Thu, 19 July 2007 08:49

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 11:03:34 CST 2024