Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Please see the Cloudera blog for information on the Cloudera Response to CVE-2021-4428

How to migrate Ambari DB from postgres to Oracle?

 
1 ACCEPTED SOLUTION

Accepted Solutions

  1. Setup Oracle schema using link
  2. CSV dump of postgres tables. example
  3. use oracle sqlldr to load data into oracle table

Or You can try this

View solution in original post

3 REPLIES 3

  1. Setup Oracle schema using link
  2. CSV dump of postgres tables. example
  3. use oracle sqlldr to load data into oracle table

Or You can try this

View solution in original post

I would strongly recommend customers to involve Oracle DBA for this.

Explorer

How to Migrate Ambari DB from Postgress to MYSQL? tried https://hortonworks.my.salesforce.com/kA0E0000000fy7d

But when I source /tmp/ambari.sql , Its failing with syntax errors . Tried using Mysql workbench But 19 tables got affected.

Thanks,

Siva.