Skip to Main Content
  • Questions

  • Can we take Full export and metadata of few tables with one EXPDP command?

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Jiten.

Asked: January 18, 2021 - 6:57 am UTC

Last updated: January 26, 2021 - 1:52 pm UTC

Version: 19c

Viewed 1000+ times

You Asked

Hello Tom,

I want to take full export of database but want to take metadata only for few huge tables. Can we do it with single EXPDP command, i have gone through some blogs and found we can do it with 2 different EXPDP hence looking for your suggestion on it.

Regards,
Jiten

and Chris said...

You can use the query clause to restrict which rows you export from a table. So you can use an always false filter (e.g. 1=0) for each table whose rows you want to exclude from the export

For example:

expdp ... query='<user>.t1:"where 1=0"' query='<user>.t2:"where 1=0"'

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Let me try that

Jiten Pansara, January 27, 2021 - 4:15 am UTC

Thanks for the response. I will try it out and let you know in case of any issues.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.