Retrieve the Initial Load Log Files

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

Learn 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 Link

For Non-Oracle Autonomous AI Database target database:

1. Use the following query to locate the IMPDAT*.log file from the ORACLE_BASE directory of the 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 the target database.

Transfer medium: Local Storage

For a 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.

For a Target database:

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

   SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'

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

Transfer medium: Object Storage

For a non-Oracle Autonomous AI Database 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. Download EXPDAT*.log from the ORACLE_BASE directory.

For a source Oracle Autonomous AI Database database:

Download EXPDAT*.log from the Bucket URI.

For a non-Oracle Autonomous AI Database target database:

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

   SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'

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