How To Specify A Percentage Of Data To Be Exported Using DataPump Export
(Doc ID 1385364.1)
Last updated on MAY 18, 2021
Applies to:Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
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:
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