Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJILL-0002Vl-0Y for pgsql-admin@arkaria.postgresql.org; Tue, 31 Mar 2020 14:58:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJILJ-0000Ne-W6 for pgsql-admin@arkaria.postgresql.org; Tue, 31 Mar 2020 14:58:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJILJ-0000NW-Mg for pgsql-admin@lists.postgresql.org; Tue, 31 Mar 2020 14:58:17 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jJILG-0003PO-Qf for pgsql-admin@lists.postgresql.org; Tue, 31 Mar 2020 14:58:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1585666693; bh=TI/Col3Mlvaz10NXcPnJpLfusu8q3Aih1j7XiDb64NY=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=Qts6HhIWBzkiHKAUrXQhbtk5b0gc5XlJ3VCq5wZH4R6HHBH6bZunIgS3YCnhCEfn9 1ZV3RqyPrJM1KBICqwWr0l/7fsDonT8g2J0ySohroUIT9PSgmeuhzrp7o3OLAluM+r Zc6eNMS1kMtqPXG3XgBhwSIeW/aBZ6ot6mnEyVUU= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.33.65] ([185.40.248.10]) by mail.gmx.com (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MQe5k-1jflB43SX0-00NgyA for ; Tue, 31 Mar 2020 16:58:12 +0200 Subject: Re: migrate off oracle data to postgres To: pgsql-admin@lists.postgresql.org References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com> <1587437647.1103378.1585664119295@mail.yahoo.com> From: Thomas Kellerer Message-ID: <079d990d-b990-e2d4-5b87-6397edb35d36@gmx.net> Date: Tue, 31 Mar 2020 16:58:12 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: <1587437647.1103378.1585664119295@mail.yahoo.com> Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:w/sVeyLjfLdySQ7orBEDPTRZJt+OSAluIBvn/tl7kyEUC/VjsJ7 PMfnh7MiYSeP3JvmO4/QhVT2aNpI13Sb/afhbV1qGLpJo4lwdzCUmRR5cOX0/bo2tKdgyBL ZxHV9tNLs4ZiognCqEPVouZ10iPr+bevCtp8s/KzFEvvC6D33MdVagHd/wSGrPQRltWDUTx tT5BfXuDFgYafKZOveBuQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:q2KkwS4u5Ew=:9dc5wnOucisP54lS1AR8FY f8ttl9RlecrWo2bnedU7Xw1lEfwcRXctTBnL378kz1MnjCGIkLXad5waV6OTSZ2UKzDqQdqm7 EIMju5ygFxy84EI0711zpcr4GQgO83CP/zdxdzxdwo+5CCNZt+lfpbK3ojD3hOlkKd5cslK0e G8ReosGeqgwZWyLqNcDQp6fgUrhlfunfZs779mNMK+Km8SEFTOFQ9ScWlPQ59S/pLEO7dJJUg Lc6TUU6lm2kEC4y2rBMA3n5PrGrRClsoVLpYHnk37D1vyB9VsbQgHBV/iSNQusivrxEFNXD7q bncbqfXKfdnaSWcAm7UPTR3NKjMKCpAznVG2prfTPnKpZoVgBHPxv02KVKBMLz5xbgE6etx70 EA/Ze7+AHdCQEwJvcmGvl73Hn5mEQqIzg1Zb7Flb5WF3m8bE/6uIDuQZVZC/N2NnOZlqBHMLi X9h8zORVwx0gCXAqhECFavZsLyKrcyVKxY7bwhqbUwSpGhBjIp3Nkveg9bd0Og/ZSoermbeC8 Ix1cyy0uv3gBOlgHjuLaba+dFHr36dguFoiBg3JAyZnmOtf0xdvStqafbdYGavWAtMUGBf8ZA 2BxCPuavAw4xs2DNY3zs1FAyzeJ3/iFkXRorPx2KJ/XTpQM9LhQ38LT8TY+SLTCk3KEI4SueS tW1J35CbjiyfGOPXEBtxiO7e9y1/HWffdIuBvKG6ZvK75mBzdVwO7K2Xti8tnGgJNJt5M7aGo z9yMUoQoHyQ8swfOITgecZzL/Lmy/8GY0SfKvf1x/1exFC1PChvFVOxyf4nhg+CW/Sat3QcPl CNVElfIlmazFFYASMH5c9a2uMeeTUsuyYHul3+8jiwmbAjrkTu1b37xh2xEgvcddnm+n3UW+K 44L/rRyzQkjoT/o4B+d4RUDjy3EPWyDER9UKLajTkGqtm+UregDBIQlz9mKQlsuFZ7w4O9C76 TRBFWQqPd3L+znYE7+yGqkStHX1tHY8Sg9n40b3bzbafZgsmBgbjDUAsTqt+P77nEBVmf8AZx NMWL7Dkvr9q1N2kDr1jhjlsqyRqRV7T5cvFvREsJby23GnOdUzQdPB6F6VdbCIEvHQYej7Ipm T4Nh2epjxsp7vYRNmdNfQnbiAfIjLBwbm5/HBkGH6WloJIcHlucGEQos/rBOs47kN/zZN7Yn6 s3/6gBV8/5Yyffx4beQCuajmPdGOU7dXHxoEvHMHhI+1u/ht29sjmLpzVMD/yQmG4FWUApLks kK1bGlCIYv5T+pE4l List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Pepe TD Vo schrieb am 31.03.2020 um 16:15: > I have a huge data on Oracle, would you please suggest how to migrate > all data off Oracle to Postgres? Do I need to export into csv and > upload to postgres? Ora2pg is limited data from oracle to postgresql > right? Not sure what you mean here. Ora2Pg can migrate the table definitions and copy data as well.