Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expdp Multiple Tables One Query

aetlJun 26 2015 — edited Jun 26 2015

Hi Everyone,

I will ask some questions.

First I have two or more tables including Column called "Yearmonth".I want to export Yearmonth between 201301 and 201312 for example.

I wrote expdp command like this :

expdp user/pass@sid DIRECTORY=IMAGE_DIR DUMPFILE=alls.dmp  TABLES=table1,table2  query=table1,table2:'"where YEARMONTH \ between 201301 and 201312"'

I am facing an error that SQL command not properly ended.

Table2 is exported only.When it starts exporting table1 ,giving an error.

I have almost 50 tables including yearmonth .

is it possible to export like this?

Any solution for this problem ?

Thanks.

Regards
This post has been answered by David Luis Moya Garrido on Jun 26 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2015
Added on Jun 26 2015
#database-key-features, #export-import-sql-loader-external-tables
4 comments
6,450 views