Re:

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(at)yahoo(dot)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
>
>