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]
PostgreSQL LazyDBA home page