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 <[EMAIL PROTECTED]> 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