Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Test Data Management - Subsetting using only percent (%)

edited Aug 14, 2015 9:51AM in Managing Databases using Enterprise Manager (MOSC) 2 commentsAnswered

My customer is looking to use Data Subsetting to reduce the size of a database for cloning purposes.  They are experiencing issues when trying to create a Subset of an application for all schemas and All Tables which is very large.  For "Rows to include" they choose 10% using the 'Some Rows' radio button.  They are not entering a WHERE clause.

For small databases with a small number of objects, the subsetting works without issue, but they tried to create a subset for large complex environments like Peoplesoft and the process fails.  The customer is working with Oracle Support, but I wanted to find out if there are any recommendations on customers trying to use Subsetting for large complex database with a large number of schemas and Tables.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center