AWS has documentation on how to do this. Check out this page: Migrating an Oracle Database to PostgreSQL
Postgres DDL (Data Definition Language) and Oracle DDL are slightly different. This will be a heterogeneous migration.
You can use AWS SCT (Schema conversion tool) to convert the Oracle schema to a Postgres schema.
Once the schema has been created on the destination Postgres DB you'll use DMS (Database migration tool) to migrate the data.
Database Migrationasked 22 days ago
migrate database from my local to AWSAccepted Answerasked 3 years ago
Is there any way to move existing database instance to a new cluster?asked 6 months ago
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 5 months ago
What's the fastest way to move a 2TB Oracle Database to EC2?Accepted Answerasked 2 years ago
Read Oracle CDC without timestamp informationasked 3 months ago
want database synchronization of few tables from AWS Prod to AWS UAT DataBaseasked 5 months ago
Migration from IBM DB2 9.5 using AWS Database Migration Serviceasked 17 days ago
Database in Amazon Glueasked 5 months ago
ETL from an Oracle database into RDS Postgres too slowAccepted Answerasked 2 years ago