Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to migrate Postgres database to Oracle?

2928666Apr 13 2015 — edited Apr 14 2015

Hi Experts,

Please guide me to migrate Postgres database to Oracle. Postgres database version is 9.2 and it is in Linux server.

can I  use Oracle SQL Developer migration tool  for migrating from Postgres to Oracle?

Please give valuable suggestions.

Regrads,

Suresh.

Comments

Robb Salzmann
Hi Shivendra

From Pg 2-1 of the WebLink Scripting Guide:
All the Hyperion FDM objects are supported in Import scripts except the Hyperion FDM “API” object.
If you need to populate 3 columns in your export from one column in your import, its easy, no scripting needed.

In your input format you simply refer that one column for each of the dimensions that need it's information.


It looks like you and James are on the same project. Help me help you, describe what you are trying to accomplish with this script. Why are you looking up maps during an import?

Regards,
Robb Salzmann
shiv2
Thanks!!

Edited by: shiv2 on Sep 16, 2011 8:56 PM
shiv2
Hi Robb,

"It looks like you and James are on the same project" That is correct.

OK. In requirment we have three-four column based on these column we need to derive few other column. We want to do spilitting and validation in Import itself. This is mainly a Validation requirment.

There is one column which may have 12,13,14,17 or any other number of character in it. first three will represent one dimension but exact value be a mapped result based on these three digits.


There are many validation based on the number on charaters and most importantly we don't want to process other column is validation get failed at any stage.

Do we have anything like Import Action? Probably we want to change that script. Or if we can write something like integration script. We need every column to be processed in one shot.

I don't think it is self explantry. Can we have your email please?

Thanks,
Shivendra

Edited by: shiv2 on Sep 16, 2011 8:52 PM
Robb Salzmann
Hi Shiv,

I'm not going to post my email address. I'm not hard to find, but you'll have to do a little work do to so.

Also I prefer to help you here where other people can benefit from the dialog. Continue to post your requirements and questions and we can get it done here.

Please provide more specifics around your question above to help me understand it - as its worded now, I'm not sure I understand what you're asking here.

Regards,
Robb Salzmann
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 12 2015
Added on Apr 13 2015
7 comments
8,577 views