And if you didn't insist on using 8i and upgraded to 10g, you could export
to flat-file using Oracle external tables and CTAS - i.e. Oracle now (10g)
has built-in flat-file dump support.

-----Original Message-----
From: b1b2
[mailto:postgresqldba-ezmlmshield-x52926851.[Email address protected]
Sent: Friday, August 04, 2006 12:02 AM
To: LazyDBA Discussion
Subject: RE: Importing Data From Oracle 8i

Hi all,

Ring Micro$oft or download a developer edition of SQLServer, then use DTS
Export/Import to migrate your data. This is the simplest way if there is no
LOB/BLOB or binary data involved. As far as I know, the SQLSERVER DEVELOPER
edition is free of charge.

Check if you can connect to ORACLE as your SOURCE and then POSTGRESQL as
your
TARGET, so you IMPORT from ORACLE to POSTGRESSQL. If you cannot, then use
ORACLE as your source and SQLSERVER as your target and then use SQLSERVER to
dump your data as flat file and bring it across to POSTGRESQL, i.e.
IMPORT from
ORACLE to SQLSERVER, then use SQLSERVER to EXPORT to flat file ...

Quoting Walker Jed S
<postgresqldba-ezmlmshield-x10748510.[Email address protected]

> Thanks Zaimi. I'll keep these myself for a possible PostgreSQL to Oracle
> conversion.
>
> -----Original Message-----
> From: zaimi
> [mailto:postgresqldba-ezmlmshield-x50468418.[Email address protected]
> Sent: Thursday, August 03, 2006 12:39 PM
> To: LazyDBA Discussion
> Subject: Re: Importing Data From Oracle 8i
>
> http://akcess.in/MigrateData.html
> http://www.swissql.com/oracle-migration.html
>
> -zaimi-
>
> Walker Jed S wrote:
>> 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]
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>> Website : http://www.LazyDBA.com
>> To unsubscribe, e-mail: postgresqldba-[Email address protected]
>>
>>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe, e-mail: postgresqldba-[Email address protected]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe, e-mail: postgresqldba-[Email address protected]






---------------------------------------------------------------------
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