Required Setup

Each script requires access to a local directory on the database server machine from within SQL*Plus.

All of the scripts write log files to this directory. The export script writes the export file to the directory and the import script reads from the file in the directory.

But since a SQL script cannot directly refer to a directory created using the operating system (OS), you must create a local database directory from SQL*Plus and map it to the local OS directory. Instructions are included in the sections on running the scripts.

You need to move the file from the export environment to the import environment through an upload and download, FTP, or any method that you use to transfer files.