I thought the original question is he wants to move to Postgres, so
really, the
10g one is just a plus if it got some features to make it less tedious to
extract record from Oracle into ASCII flat files ...

10g upgrade is not really necessary so long as it can read the Oracle8i export
dump. I know 10g can't connect to 8.1.6 databases anymore on my end here but
whether the same issue applies to export/import is another thing to
look at ...

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

> However, if you are going from 8i to 10g I would highly recommend doing
> an export/import. This allows you to implement Locally Managed
> Tablespaces (and defragment) and others features. Also, some features
> are supposedly not enabled on an upgrade, so creating from scratch as
> 10g and importing buys you a lot.
>
> -----Original Message-----
> From: mail.bresnan.net
> [mailto:postgresqldba-ezmlmshield-x99643672.[Email address protected]
> Sent: Tuesday, August 08, 2006 9:50 AM
> To: LazyDBA Discussion
> Subject: RE: Importing Data From Oracle 8i
>
> 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]
>
>
>
> ---------------------------------------------------------------------
> 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