RE: [EXT] Re: Oracle data to PG

Поиск
Список
Период
Сортировка
От Pierson Patricia L (Contractor)
Тема RE: [EXT] Re: Oracle data to PG
Дата
Msg-id SJ0PR09MB6061AE9CAE06AE213C9AF920C7969@SJ0PR09MB6061.namprd09.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Oracle data to PG  (Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>)
Список 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.santamaria@gmail.com>
Sent: Thursday, July 28, 2022 6:19 AM
To: Dischner, Anton <Anton.Dischner@med.uni-muenchen.de>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXT] Re: Oracle data to PG

 

 

On Thu, Jul 28, 2022 at 10:56 AM Dischner, Anton <Anton.Dischner@med.uni-muenchen.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Juan José Santamaría Flecha
Дата:
Сообщение: Re: Oracle data to PG
Следующее
От: Pepe TD Vo
Дата:
Сообщение: Re: Oracle data to PG