Let’s say we have a very big table, and for testing purpose, we need only a subset of data i.e to let’s say 10 percent of data from that table, then SAMPLE parameter can be used in EXPDP. We will explain its use in below demo.

SAMPLE
Percentage of data to be exported.

DEMO:

PARFILE WITH SAMPLE OF 10 PERCENT.

It has exported around 21890 rows which are around 10 percent of actual rows in the table (219456).