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