5.6.6.1 Export from Sandbox

Note:

This section is intended for DBA/UNIX Admin.

1. Provide read/write/execute permissions to Export_Sandbox_Data.sh
2. Execute following Unix command dos2unix Export_Sandbox_Data.sh
3. Following grants are needed on Sandbox_Schema / Export_Schema ( using sysdba )

   grant read, write on directory DATA_PUMP_DIR to export_schema_name;

   grant export full database to export_schema_name;

4. Execute the export utility using the following command

   ./Export_Sandbox_Data.sh

   1. Provide Oracle schema details when prompted
   2. Model Group Name will also be captured as part of inputs.

Outputs

AIF_DATA.dmp will be created as part of successful execution.

Execution Logs

EXP_AIF_DATA.log will be created as part of the execution in case of any issues.

Note:

Oracle Drive Compatibility:

1. This utility can be executed from the same BD folder if the oracle drivers for the BD client and sandbox database server are compatible.
2. If not compatible, this utility can be copied to the database UNIX server of the sandbox schema under the folder DATA_PUMP_DIR.
3. DATA_PUMP_DIR for any oracle database server can be found out using the following query (using sysdba) select * from dba_directories where directory_name = 'DATA_PUMP_DIR'