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...
3
answers
0
votes
54
views
asked 5 days 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
95
views
asked 14 days 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
239
views
asked a month 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
75
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
73
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
1474
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
330
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
688
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
587
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
335
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
273
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...
1
answers
0
votes
2771
views
asked 2 years agolg...