Skip to Main Content

Oracle Database Discussions

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!

Datapump : export only half of the data

user13117585Dec 6 2020

Hi folks,
I need to export a table from one database and import it to another one. My idea was to do that with datapump. The table is huge (almost 1TB). In the second database, I don't need it all. I only need part of the data (it's for test purposes and it doesn't really matter if not all the data are there).
So, I was wondering if it is possible to limit the amount of data exported by datapump?

Regards,

This post has been answered by cormaco on Dec 6 2020
Jump to Answer
Comments
Post Details
Added on Dec 6 2020
2 comments
739 views