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

Export/Import with OEM12c

OEM12c is also the GUI tool for Data Pump; here we can easily perform the following operations with Data Pump:

  • Transport tablespaces
  • Export to an export file (dump file)
  • Import from an export file (dump file)
  • Import from a database (using database link)
  • Load data from user files (external tables)
  • View export and import jobs

As you can see, OEM12c allows us to basically do almost all of the most important operations available with Data Pump. For this chapter, we will only take a closer look at how to execute an export operation via OEM12c and how to view its job execution.

Executing an export operation

To perform an export via OEM12c, firstly we will need to navigate in the database console (for this example, we will use the pluggable ...

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