Обсуждение: Postgresql To Oracle9i

Hello,
Atul here From india.Anyone who knows how to mirgrate the data from
postgresql7.2 to Oracle9i.Please give the idea or methood to transfer the
data.

Thank you.

Regards,
Atul...

Atul Pedgaonkar wrote:
> 
> Hello,
> 
>         Atul here From india.Anyone who knows how to mirgrate the data from
> postgresql7.2 to Oracle9i.Please give the idea or methood to transfer the
> data.

Use pg_dump to create separate schema and data (as INSERT statements)
dumps. Edit the schema so that Oracle is happy with it and run the two
SQL scripts.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #