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 <[EMAIL PROTECTED]> 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............... > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
