How To Specify A Percentage Of Data To Be Exported Using DataPump Export
Last updated on JANUARY 23, 2012
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms