You don't export, you upgrade in place. Just install the new home, shutdown
the current db, startup upgrade then run the u0817xxx.sql script from
$OHOME/rdbms/admin/ and the 8i db is upgraded to 10g.

-----Original Message-----
From: b1b2
[mailto:postgresqldba-ezmlmshield-x12918464.[Email address protected]
Sent: Sunday, August 06, 2006 1:48 PM
To: LazyDBA Discussion
Subject: RE: Importing Data From Oracle 8i

Exactly, 8i is getting de-supported already so you may as well export your
Oracle8i to 10g, free download anyway, you may have more options available
in
10g that you can use ...

Quoting "mail.bresnan.net" <postgresqldba-ezmlmshield-
x87903052.[Email address protected]

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