Skip to Main Content
  • Questions

  • Data pump export to multiple mount points

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

Asked: November 09, 2016 - 11:32 am UTC

Last updated: November 11, 2016 - 4:20 pm UTC

Version: 11g

Viewed 1000+ times

You Asked


How to export a schema with size 500GB to different mount points using datapump?

Expamle

Shema size 500gb
Mount point size /disk1 200gb
/disk2 200gb
/disk3 200gb


I need to do export using above mount points.

Thanks & Regards
Krishna

and Chris said...

If the export is too big to fit in one location you'll need to split it up into tables that total 200Gb or less. Specify these with the tables parameter. You can find their current sizes by querying user_segments.

Or you can reduce the size of the export by:

- Compressing the dump file (requires Advanced Compression license)
- Do a meta data only export to get all the DDL. Then a second export of the data excluding indexes (EXLUDE=INDEX) and other objects like materialized views.

Is this answer out of date? If it is, please let us know via a Comment
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.