Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFKf2-0001lv-FG for pgsql-general@arkaria.postgresql.org; Mon, 29 May 2017 13:24:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dFKf2-0000A1-1t for pgsql-general@arkaria.postgresql.org; Mon, 29 May 2017 13:24:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFKcb-0004HP-GB for pgsql-general@postgresql.org; Mon, 29 May 2017 13:22:09 +0000 Received: from smtp3.hushmail.com ([65.39.178.200]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFKcY-0007rh-IR for pgsql-general@postgresql.org; Mon, 29 May 2017 13:22:07 +0000 Received: from smtp3.hushmail.com (localhost [127.0.0.1]) by smtp3.hushmail.com (Postfix) with SMTP id 30F6BE0C15 for ; Mon, 29 May 2017 13:22:05 +0000 (UTC) Received: from smtp.hushmail.com (w6.hushmail.com [65.39.178.92]) by smtp3.hushmail.com (Postfix) with ESMTP; Mon, 29 May 2017 13:22:03 +0000 (UTC) Subject: Re: Oracle to PostgreSQL Migration. To: PAWAN SHARMA Cc: pgsql-general@postgresql.org References: <342051cfd508755a032d133ed0ab666e@smtp.hushmail.com> <85c78636081d539aa0cfdd8380c37d52@smtp.hushmail.com> From: Chris Mair Message-ID: <3834a5518765eb2c1283f7bb86cd9fe4@smtp.hushmail.com> Date: Mon, 29 May 2017 15:21:56 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org > [========================>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) > [============> ] 1/2 total rows (50.0%) - (4 sec., avg: 0 recs/sec). > Out of memory! ] 1/2 rows (50.0%) on total estimated data (4 sec., avg: 0 recs/sec) > Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Oracle::db handle (DESCRIPTION=(ADDRESS=(PO > RT=1521)(PROTOCOL=tcp)(HOST=))(CONNECT_DATA=(SID=))) at C:/Strawberry/perl/vendor/ > lib/DBD/Oracle.pm line 348. > > > So, It will show data enter in mytab 100% but in test it is 50%. but when I checked on PostgreSQL server their data only in one table. Did you notice the "Out of memory!" you got there? I guess that's the problem now... Bye, Chris. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general