Help improve AWS Support Official channel in re:Post and share your experience - complete a quick three-question survey to earn a re:Post badge!
All Content tagged with Oracle to PostgreSQL
Expert conversation about Migration problems related to migrating Oracle applications and databases to PostgreSQL.
Content language: English
Select tags to filter
Sort by most recent
16 results
Hello
In a Oracle to Postgres DMS task, I try to select particular columns from source, and convert from the Oracle uppercase default , to the Postgres lowercase.
They are work great alone, but if I...
We cannot find any official Documentation covering AWS SCT Oracle source version.
Can you please confirm if it can works for Oracle 9.2.0.8 as Source for both assessment and conversion to RDS for Po...
Hi Team,
I have an Aurora PostgreSQL instance running version **14.9** on a **db.r6g.2xlarge ** instance type (Memory-optimized). Recently, the server's CPU usage has increased to around **99.5%**. I...
Hi,
I am wanting to migrate some tables from Oracle to PostgreSQL. Only 5 out of 50 tables.
I used ora2pg to generate the DDL and created the tables.
I only want to migrate some columns of these 5 t...
I'm doing a test migration (Oracle to Postgres) of a single table (9K rows, 0.01GB, has 1 BLOB field) to prove that it works.
But it becomes stuck without further events for 1h+ .
Replication type: F...
In DMS, when creating either a Data Provider or Endpoint (source), my Oracle RDS (19c, Standard Two, CDB) is not visible as a choice. A different RDS (Postgres) from same VPC, same subnets (private), ...
I am trying to convert Oracle schema to Postgres 13.7 with SCT, SCT assessment report shows following
postgresql does not support foreign keys that referencing partitioned tables
As per Postgres docum...
asked 3 years ago
I am busy configuring the oracle_fdw to access data from on-premises Oracle databases in AWS RDS Aurora Postgres databases. When using a listener with a TCP port the connection works and the data is a...
I am migrating data from Oracle materialized view to PostgreSQL using DMS CDC. Initial load completed successfully. I do not see the changes are replicating. Is any one has performed this type of mig...
I got the below error from glue job
Jul 19, 2022, 9:45:00 PM Pending execution
2022-07-20 01:45:13,382 main WARN JNDI lookup class is not available because this JRE does not support JNDI. JNDI string...
Hello,
We are using AWS DMS and we run into an issue.
We are using DMS engine version 3.4.6 with Oracle 11.2.0.4 as source and PostgreSQL 13.3 destination.
At some point during the on-going replica...
asked 3 years ago
I need to replicate data from Oracle database(views) to Postgres . please let me know the best to do it.I believe AWS Glue can help in replicating ETL data, If you have any documents(step by step ins...