After a subset is defined, analyzed, and validated, you can execute the subset operation to create a subset version of the source data.
The procedure assumes the following prerequisites:
A subset definition already exists that contains the rules needed to subset the database.
You have the requisite privileges to extract the data from the source and create the subset version in a target database. Depending on the subset technique, different levels of file or database privileges may be created. The required privileges include:
EM_ALL_OPERATOR
for Enterprise Manager Cloud Control users
SELECT_CATALOG_ROLE
for database users
SELECT ANY DICTIONARY
privilege for database users
DBA privileges on a database for target database users
Additionally, to perform an in-place delete operation, the DBA user must be granted the EXECUTE_ANY_TYPE
privilege
To create a subset version of a target database:
Create a subset operation by selecting a subset definition and associating it with a source database.
Enterprise Manager validates the subset definition against the source database and flags schema differences. Note that this association may be different from the original association that an application developer may have created.
Edit the definition to remap the defined schema to a test schema.
You are prompted to connect to a database, whereupon the database is associated with the subset definition. This also enables you to remap the vendor-provided schema names to actual schema names in the database.
Select one of the various subset creation techniques:
Data Pump dump file followed by a Data Pump import
In-place delete, in which rows in the specified database not matching the rule conditions are deleted
In-transit subset creation or refresh
Enterprise Manager generates the appropriate response file (that is, SQL script, Data Pump script, or OS script), checks the target system for appropriate privileges to be able proceed with the operation, and estimates the size of the target.
After reviewing the analysis, submit the subset process.
Enterprise Manager executes the subset process and summarizes the results of the execution.