On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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_impor t
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
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>
