4.3.1 Prerequisites

Prerequisites for exporting and importing Data Objects.

Prerequisites for Export

Complete the following tasks before exporting the Data Objects from the On-Premise environment:

• Create a Physical Directory in the Database Server with sufficiently large disk space to hold the exported data files (.CSV files), in the UNIX environment.

  Example: mkdir ‘/home/ofsa_export_dir’

  Note:

  Using CHMOD command, give Write permission to Oracle Processes , for the new physical directory.

  Example : chmod -R 777 /home/ofsa_export_dir

• Log in to the Database with SYS Privileges and execute the following tasks in SQLPLUS command.
  • Create a Database Directory pointing to the Physical Directory.

    Example: create or replace directory OFSA_EXPORT_DIR as '/home/ofsa_export_dir'.

  • Grant the INFODOM-SCHEMA-USER write permissions to OFSA_EXPORT_DIR.

    Example GRANT READ, WRITE ON DIRECTORY OFSA_EXPORT_DIR TO <INFODOM-SCHEMA-USER>;

Prerequisites for Import

After exporting the data from the On-Premise environment, complete the following tasks:

Note:

The following steps are required only if the physical directory is not a shared mount.

• Archive all the generated CTL and CSV files and the archive file name should be ofsa_export_dir.zip.

  Example - zip -r ofsa_export_dir.zip ofsa_export_dir

• Move generated ofsa_export_dir.zip from Database Server to $FIC_HOME/utility/Data_Export_to_SaaS/data_dumps directory in the On-Premise environment.