Re: anyone use Ora2Pg?

Поиск
Список
Период
Сортировка
От Johnson, Shaunn
Тема Re: anyone use Ora2Pg?
Дата
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FED8C3@snt452.corp.bcbsm.com
обсуждение исходный текст
Ответ на anyone use Ora2Pg?  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Ответы Re: anyone use Ora2Pg?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general

--howdy - thanks for the reply ...

--i had tried to use 'copy', but it was taking
--so long ... it took over a weekend to load
--about the same amount of records as using 'insert' (i have
--been running this program for over 2 days and only
--have 2800 records to show out of 1/2 a million records).

--i was looking for something faster.  could be my server ...
--looking at the system usage, it doesn't seem very high.

-X

-----Original Message-----
From: Stephen Frost [mailto:sfrost@snowman.net]

* Johnson, Shaunn (SJohnson6@bcbsm.com) wrote:
> Has anyone used the Ora2Pg tool for exporting
> data to PostgreSQL?  I'm trying to move data
> over, and my perl script to insert records
> into the PostgreSQL table is going very slowly.

Use copy?  I'm pretty sure that's what I did...

        Stephen

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: anyone use Ora2Pg?
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: Outer Join help please