Thread: oracle to postgresql

Hi, Can anyone tell me how do i transfer my database
from oracle to postgresql (from sun solaris to linux
machine).I installed postgresql and crete a user login
postgres and created a database and a table same as
the one in oracle.Now i need to transfer the data to
this table.
Thanks in advance for your help.

Amit

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Dunno if you are asking for generic help using oracle 'exp'
and postgres 'COPY'? Check out those commands.

If you are looking for hidden gotchas about differing
SQL grammar changes, check out:

http://openacs.org/doc/openacs/html/oracle-to-pg-porting.html

James

>>>>> "Amit" == Amit Lamba <amit_lamba99@yahoo.com> writes:
   Amit> Hi, Can anyone tell me how do i transfer my database from   Amit> oracle to postgresql (from sun solaris to
linuxmachine).I   Amit> installed postgresql and crete a user login postgres and   Amit> created a database and a table
sameas the one in oracle.Now   Amit> i need to transfer the data to this table.  Thanks in   Amit> advance for your
help.
   Amit> Amit