Retrieve the Initial Load Log Files

Retrieve the initial load log files depending on the transfer medium and type of database.

The following table describes how to determine the location of the initial load log files and access them, depending on the type of database and the transfer medium:

Transfer Medium Database Action

Database Link

Target database, non-Oracle Autonomous Database
  1. Use the following query to locate the IMPDAT*.log file from the ORACLE_BASE directory of target database.
    SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'
  2. View or Copy IMPDAT*.log files from the ORACLE_BASE directory of target database.

Local Storage

Source database
  1. Use the following query to locate the EXPDAT*.log file from the ORACLE_BASE directory of the source database.
    SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'

  2. View or Copy EXPDAT*.log files from the ORACLE_BASE directory.

Local Storage

Target database

  1. Use the following query to locate the IMPDAT*.log file from the ORACLE_BASE directory of target database. 

    SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'

  2. Copy IMPDAT*.log files from the ORACLE_BASE directory of target database.

Object Storage

Source database, Non-Oracle Autonomous Database

  1. Use the following query to locate the EXPDAT*.log file from the ORACLE_BASE directory of the source database.
    SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'

  2. Download EXPDAT*.log from ORACLE_BASE directory.

Object Storage

Source Database, Oracle Autonomous Database

Download EXPDAT*.log from the Bucket URI.

Object Storage

Target databsae, non-Oracle Autonomous Database

  1. Use the following query to locate the IMPDAT*.log file from the ORACLE_BASE directory of target database. 

    SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'

  2. Download IMPDAT*.log from the ORACLE_BASE directory.