I think you'll want to use SQL Loader to load the data out of the Oracle
database. Once that is done you should be able to modify those dump
files with a PostgreSQL COPY command (like you see in a pg_dump file) to
load the data in.

Another option would be to use programming tool and connect to both DBs
and push the data across.

There might be other better ways?

-----Original Message-----
From: krishnaraj D
[mailto:postgresqldba-ezmlmshield-x36826641.[Email address protected]
Sent: Wednesday, August 02, 2006 2:01 PM
To: LazyDBA Discussion
Subject: Importing Data From Oracle 8i

Hi Everybody .,

I am new to this community and i will be happy if anyone
clarifies my Doubt ..,

I have a databse running in Oracle 8i , Now i need to Convert this to
Postgresql-8.1.4 , the Architecture is created , the Create Table
Scripts are all run and tables are ready in postgres.

_Now i need to export data`s from ORACLE Database and import it into
POSTGRES __Database__ . Is there any simple way to do so .., ?

_Thanks in Advance

Krishnaraj D



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe, e-mail: postgresqldba-[Email address protected]


PostgreSQL LazyDBA home page