There are some tools.. search about Ora2PG or so
One other way to go is to have the Oracle DB dumped out as text and
change/review the statements to suit your new structure and PG
differences
You definitely need mass changing tools with regular expressions.
On 11/9/05, zenith Das <zenith_das@yahoo.com> wrote:
>
> Hi
> Can anyone help me out........
> How can i migrate database from oracle9i to postgreSQL8.0.3 where the table
> structure may differ in certain way...............
>
>