Re: [GENERAL] Oracle to PostgreSQL Migration.

Поиск
Список
Период
Сортировка
От PAWAN SHARMA
Тема Re: [GENERAL] Oracle to PostgreSQL Migration.
Дата
Msg-id CAPgXFMTzrHYvWFSkZYDk=NvbMguzE9DzOFnXcPWJGdFuoeMncA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Oracle to PostgreSQL Migration.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения

On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 05/29/2017 06:40 AM, PAWAN SHARMA wrote:


    ya, but how can fix it.??

    because memory is not an issue on both the server.


Hi Chris,

I am able to get the output script in output.sql but now data migration is the big problem.

http://ora2pg.darold.net/documentation.html#postgresql_import

--
Adrian Klaver
adrian.klaver@aklaver.com


Thanks all,

now it's working After DATA_LIMIT    15000 in ora2pg.conf.

test migration is successful. 


C:\ora2pg>ora2pg -c ora2pg.conf
[========================>] 2/2 tables (100.0%) end of scanning.
[>                        ] 0/2 tables (0.0%) end of scanning.
[========================>] 2/2 tables (100.0%) end of table export.
-- Generated by Ora2Pg, the Oracle database Schema converter, version 18.1
-- Copyright 2000-2017 Gilles DAROLD. All rights reserved.
-- DATASOURCE: dbi:Oracle:host=<servername>;sid=<mysid>;port=1521

SET client_encoding TO 'UTF8';

\set ON_ERROR_STOP ON


CREATE TABLE mytab (
        id bigint,
        name varchar(30),
        dt timestamp
) ;

CREATE TABLE test (
        id bigint,
        name varchar(30)
) ;
[========================>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
[============>            ] 1/2 total rows (50.0%) - (4 sec., avg: 0 recs/sec).
[========================>] 1/1 rows (100.0%) Table TEST (0 recs/sec)
[========================>] 2/2 total rows (100.0%) - (261 sec., avg: 0 recs/sec).
[========================>] 2/2 rows (100.0%) on total estimated data (262 sec., avg: 0 recs/sec)
C:\ora2pg>

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: [GENERAL] Memorial Day
Следующее
От: Kaiting Chen
Дата:
Сообщение: [GENERAL] Does NUMERIC lose precision?