Troubleshooting - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Troubleshooting

The two most common problem areas when working with Oracle as a source and PostgreSQL as a target are: supplemental logging and case sensitivity.

  • Supplemental logging – With Oracle, in order to replicate change data, supplemental logging must be enabled. However, if you enable supplemental logging at the database level, it sometimes still needs to be enabled when new tables are created. The best remedy for this is to allow Amazon DMS to enable supplemental logging for you by using the extra connection attribute:

    addSupplementalLogging=Y

  • Case sensitivity: Oracle is case-insensitive (unless you use quotes around your object names). However, text appears in the upper case. Thus, Amazon DMS defaults to naming your target objects in the upper case. In most cases, you’ll want to use transformations to change schema, table, and column names to lower case.

For more tips, see Troubleshooting migration tasks.

To troubleshoot issues specific to Oracle, see Troubleshooting Oracle Specific Issues.

To troubleshoot PostgreSQL issues, see Troubleshooting PostgreSQL Specific Issues.