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:
UsingCHMOD
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 toOFSA_EXPORT_DIR
.Example
GRANT READ, WRITE ON DIRECTORY OFSA_EXPORT_DIR TO <INFODOM-SCHEMA-USER>;
- Create a Database Directory pointing to the Physical
Directory.
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
andCSV
files and the archive file name should beofsa_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.