Exporting data using Oracle Data Pump in Oracle Database Vault environment

In Oracle Database 12c, it is possible to perform Oracle Data Pump regular and transportable export and import operations in the Oracle Database Vault environment.

Note

The process of exporting and importing data in Oracle Database 12c is a bit different than in Oracle Database 11g. The default rule set Allow Oracle Data Pump Operation is deprecated.

In this recipe, you'll export data that resides in a schema that is protected by a realm.

Getting ready

It is assumed that:

• You are using Oracle Database 12.1.0.2 (the traditional architecture) on Linux

• Sample schemas are installed (you'll use HR schema in this recipe)

• Database Vault is enabled and configured (a Database Vault owner is user dbv_owner, account manager is user dbv_acctmgr, and realm that protects HR schema is created). This is one way how you can create HR realm:

SQL> connect dbv_owner
SQL> BEGIN
 DBMS_MACADM.CREATE_REALM(
  realm_name    => 'HR Realm...