Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

How to migrate Ambari DB from postgres to Oracle?

 
1 ACCEPTED SOLUTION

  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

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.