Migrate Oracle collections to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL

This article discusses how to migrate Oracle collections to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL. It provides examples and best practices for migrating simple collections, composite collections, nested composite collections, multi-dimensional collections, and composite multi-dimensional collections from Oracle to PostgreSQL.

Specifically, the article covers:

• Overview of representing Oracle collections in PostgreSQL using arrays
• Migrating a simple collection using BULK COLLECT to PostgreSQL arrays with the array_agg function
• Migrating a composite collection to PostgreSQL by creating user-defined types and domains
• Migrating a nested composite collection by creating nested types in PostgreSQL
• Migrating a multi-dimensional collection to PostgreSQL by creating multi-dimensional array domains
• Migrating a composite multi-dimensional collection by combining nested types and multi-dimensional arrays
• Conclusion and clean up steps