Questions tagged with Oracle to PostgreSQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
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...
4
answers
0
votes
235
views
asked a month agolg...
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:...
2
answers
0
votes
235
views
asked a month agolg...
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),...
1
answers
0
votes
255
views
asked 2 months agolg...
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...
0
answers
0
votes
81
views
asked 2 years agolg...
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...
0
answers
0
votes
81
views
asked 2 years agolg...
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...
2
answers
0
votes
1522
views
asked 2 years agolg...
Error from Glue joblg...
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...
1
answers
0
votes
362
views
asked 2 years agolg...
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...
1
answers
0
votes
752
views
asked 2 years agolg...
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...
2
answers
0
votes
609
views
asked 2 years agolg...
I am doing migration from Oracle to postgres. DMS migrated several tables without any issues, I am having issues with few tables on validation. Validation issues should be on...
1
answers
1
votes
360
views
asked 2 years agolg...
I am doing reactoring from Oracle to Postgres, as part of it I am doing replication from Oracle to postgres using DMS. Do I need to drop foreign key on postgres before I start the DMS?
2
answers
0
votes
287
views
asked 2 years agolg...
I have ran DMS , which migrates data from Oracle to postgres. After the migration DMS shows mimsatched records and it shows around 600 records mismatched. Is there any we can identify and fix this...
2
answers
0
votes
2872
views
asked 2 years agolg...