O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Advanced Data Pump

Many people don't know about several powerful functionalities that are available when using Data Pump (expdp/impdp). Most of the people only use these tools to export and import data (in other words, only to move data), and never notice that it can be used, for example, to help us to do:

  • Data masking
  • Build a metadata repository
  • Create a version control
  • Work with different object editions in a database
  • Clone users (create a new user using an existent user as a template)
  • Create smaller copies of production
  • Create your database in a different file structure
  • Move all objects from one tablespace to another
  • Move an object to a different schema (a simple example, change a table owner)
  • Migrate data for a database upgrade
  • Downgrade ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required