QuestionQ69

VerifiedMigrate data solutions

You are using Database Migration Service to migrate an on-premises Oracle database to Cloud SQL for PostgreSQL. You observe that DML changes for one important production table are not being replicated to the target, while every other table is migrating to the target without errors.

What could be causing this problem, and what should you do to resolve it?

Explanation

Oracle index-organized tables (IOTs) are not supported for heterogeneous Oracle-to-Cloud SQL for PostgreSQL migrations with Database Migration Service. Convert the affected table to a normal heap-organized table so its data changes can be migrated.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!