Dear Subhas,
There are many approaches.
1. dump the data to a sql script file , you may use -D option with pg_dump for max portability
2. use DBI
the exact process depends on the complexity of data , number of tables type of data etc.
i think you should migrate to a newer version of postgresql like 8.1.5 or
the upcoming 8.2 version instead of oracle.
regds
mallah.
On 10/31/06, SUBASH CHANDRA MOHAPATRA <subashchandramohapatra@yahoo.com> wrote:Hi All,
Please help me how to migrate from the postgresql 7.4 to oracle 9i .
Please let me know the process and the script also
Regards,
Subash