| From: | "Pierson Patricia L (Contractor)" <Patricia(dot)L(dot)Pierson(at)irs(dot)gov> |
|---|---|
| To: | "juanjo(dot)santamaria(at)gmail(dot)com" <juanjo(dot)santamaria(at)gmail(dot)com>, "Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)de" <Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)de> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: [EXT] Re: Oracle data to PG |
| Date: | 2022-07-28 12:28:01 |
| Message-ID: | SJ0PR09MB6061AE9CAE06AE213C9AF920C7969@SJ0PR09MB6061.namprd09.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Dumping to CVS is fine for small simple tables. Watch for BLOB/LOBs. May need
to have Oracle DBAs write a plsql proc to dump
From: Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com>
Sent: Thursday, July 28, 2022 6:19 AM
To: Dischner, Anton <Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)de>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: [EXT] Re: Oracle data to PG
On Thu, Jul 28, 2022 at 10:56 AM Dischner, Anton
<Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)de
<mailto:Anton(dot)Dischner(at)med(dot)uni-muenchen(dot)de> > wrote:
we are searching for a way to import a dump from an Oracle Installation into
PostgreSQL.
Ist not administrated by us, so foreing table or connect as an user (as ora2pg
seems to need) is not an option.
Why don't you have the Oracle people dump the data you need into a CSV file
and COPY it into Postgres?
Regards,
Juan José Santamaría Flecha
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pepe TD Vo | 2022-07-28 13:29:26 | Re: Oracle data to PG |
| Previous Message | Juan José Santamaría Flecha | 2022-07-28 12:18:43 | Re: Oracle data to PG |