Database Backup and Recovery (MOSC)

MOSC Banner

Building a test database from a large/complex source database

edited Jun 3, 2012 10:11AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
I need to duplicate a complex source database to a different architecture (Solaris on Sun Sparc to Linux on Intel).  I only need to copy a portion of the data. We've tried using Transportable Tablespaces, but the datapump export fails and Oracle hasn't been able to determine why or give us a work around.  So, can anyone recommend a good process (a white paper would be great!).
I'm thinking that I can use datapump (which does normal exports just fine) to transfer the schemas.  I can't transfer the data via datapump because of space and time constraints.  Can you recommend a good process for transferring only a portion of the data from the source database?

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