5.6.6.2 Import into Production

Note:

This section is intended for DBA/UNIX Admin.

1. Copy AIF_DATA.dmp (output of export) and Import_Sandbox_Data.sh to DATA_PUMP_DIR of BD Production Database server.
2. Provide read/write/execute permissions to AIF_DATA.dmp and Import_Sandbox_Data.sh
3. Execute following Unix command:

   dos2unix Import_Sandbox_Data.sh

4. Following grants are needed on BD Production Schema / Import Schema ( using sysdba )

   GRANT read, write on directory DATA_PUMP_DIR to import_schema_name;
   GRANT import full database to import_schema_name;

5. Execute the import utility using the following command:

   ./Import_Sandbox_Data.sh

   1. Provide Oracle schema details of the importing schema when prompted
   2. The Export schema user name / ID will also be captured as part of inputs.

Outputs

On successful execution, AIF_BEHAVIORAL_DATA & AIF_NON_BEHAVIORAL_DATA will be populated for the model group.

Execution Logs

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

Note:

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'