How To Specify A Percentage Of Data To Be Exported Using DataPump Export (Doc ID 1385364.1)

Last updated on JANUARY 23, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.3 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Goal

How to specify a percentage of the data rows to be sampled and unloaded from a source database using DataPump export utility.

The parameter to do that task is called sample:

SAMPLE=[[schema_name.]table_name:]sample_percent

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.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms