Row-Limiting Clause via DataPump

The row-limiting clause in Oracle 12c is available for use in a variety of ways and applications. I've discussed two of them in this blog (CTAS with Row-Limiting Clause and Row-Limiting Clause with Effective Dated Rows). 

With Oracle DataPump, you can use the Row-Limiting Clause by specifying it as part of a subquery data filter. See the example below: 

DataPump still continues to have the SAMPLE data_filter, but samples taken this way are applied to block level samples, not row level samples. 

From Oracle's DBMS_DATAPUMP doc: 

For Export jobs, specifies a percentage for sampling the data blocks to be moved. This filter allows subsets of large tables to be extracted for testing purposes.

If you need a true subset of rows exported from a table, use the row-limiting clause with a data filter.