How To Specify A Percentage Of Data To Be Exported Using DataPump Export
(Doc ID 1385364.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199 to 188.8.131.52 - Release: 11.2 to 11.2
Information in this document applies to any platform.
The parameter to do that task is called sample:
This parameter allows you to export subsets of data by specifying the percentage of data to be sampled and exported. The sample_percent indicates the probability that a row will be selected as part of the sample. It does not mean that the database will retrieve exactly that amount of rows from the table. The value you supply for sample_percent can be anywhere from .000001 up to, but not including, 100.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document