View a markdown version of this page

Using an Oracle Data Warehouse database as a source in DMS Schema Conversion - AWS Database Migration Service

Using an Oracle Data Warehouse database as a source in DMS Schema Conversion

You can use Oracle Data Warehouse databases as a migration source in DMS Schema Conversion to convert database code objects and application code to Amazon Redshift.

For information about supported Oracle database versions, see Source data providers for DMS Schema Conversion. For more information about using DMS Schema Conversion with a source Oracle database, see the Oracle to PostgreSQL migration step-by-step walkthrough.

Privileges for using an Oracle Data Warehouse database as a source

The following privileges are required for Oracle Data Warehouse as a source:

  • CONNECT

  • SELECT_CATALOG_ROLE

  • SELECT ANY DICTIONARY