Perform Source Database Related Prerequisites

You must review and perform the following tasks, if required, to export data from the on-premises Oracle Database.

  • Ensure that you have the DATAPUMP_EXP_FULL_DATABASE role, if you want to export database schemas that do not belong to you.

    Note that this role will only enable you to perform the export operation from the source on-premises Oracle Database. For more information on the Oracle Data Pump export utility role, see Required Roles for Data Pump Export and Import Operations in Oracle Database Utilities.

  • Ensure that the directory object in which the exported dump files will be stored is available and has enough space. For databases, the default DATA_PUMP_DIR directory object exists and you can use it or create a new directory object. However, for Pluggable Databases (PDBs), you'll have to create a directory object. You must also ensure that you have READ and WRITE access to the directory object.

    To create a directory object and provide access:

    $ mkdir -p <directory_location>
    CREATE OR REPLACE DIRECTORY <name_of_the_directory_object_in_the_db> AS <directory_location>;
    GRANT WRITE ON DIRECTORY <name_of_the_directory_object_in_the_db> to <user_name>;
    GRANT READ ON DIRECTORY <name_of_the_directory_object_in_the_db> to <user_name>;

    Important: Make a note of the <name_of_the_directory_object_in_the_db> as you'll need it when submitting the source database details on the Data Movement page.

    Note that in an Oracle Real Application Clusters (RAC) environment, the directory object location should be a shared location, which is shared across all the nodes.

Install Oracle Instant Client

You must download and install the Oracle Instant Client to connect to the destination Autonomous Database. The Oracle Instant Client must be installed on the same host on which you installed the Cloud agent that orchestrates the data movement operation.

To download the Oracle Instant Client:

  1. Go to the Oracle Instant Client page and click Download.
  2. On the Oracle Instant Client Downloads page, click Instant Client for Linux x86-64.
  3. On the Instant Client Downloads for Linux x86-64 (64-bit) page, select the Accept the License Agreement option and download and install the following:
    • Basic Package – Includes the files required to connect to the destination Autonomous Database.
    • Tools Package – Includes Data Pump, SQL*Loader and Workload Replay Client.
    • SQL*Plus Package – Includes the SQL*Plus command line tool for SQL and PL/SQL queries.

Important: Make a note of the Instant Client Location as you'll need it when submitting the source database details on the Data Movement page.