Forum Stats

  • 3,780,468 Users
  • 2,254,399 Discussions
  • 7,879,341 Comments

Discussions

Datapump : export only half of the data

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,

Tagged:

Best Answer

Answers

  • user13117585
    user13117585 Member Posts: 641 Bronze Badge

    THANK YOU,

    I feel sorry... I should have read the documentation!!