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 1jJJE6-0000Ok-KZ for pgadmin-support@arkaria.postgresql.org; Tue, 31 Mar 2020 15:54:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJJE4-0004at-6o for pgadmin-support@arkaria.postgresql.org; Tue, 31 Mar 2020 15:54:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJJE3-0004ak-Vz for pgadmin-support@lists.postgresql.org; Tue, 31 Mar 2020 15:54:51 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJJE1-0002OJ-6A for pgadmin-support@lists.postgresql.org; Tue, 31 Mar 2020 15:54:50 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 686945C05F9; Tue, 31 Mar 2020 11:54:48 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 31 Mar 2020 11:54:48 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= subject:to:references:from:message-id:date:mime-version :in-reply-to:content-type:content-transfer-encoding; s=fm2; bh=E Mz4i2+GN3cuAUY818q72KeTEkZFkjcX3PB7nB+6/O0=; b=nfMRm/vgLc9wbhY9E 6lGCf/R8zFAbpQw3b+bpQwRyG5hb3dzEPvvSLB/dwqqSoRGI5yy0gpLTwlsjMNdC bPA5qrL6teKmZ3ywUSUa0jiHoZatcYuABZkGnlOVNKBVqVLz6rul97SFRpMSmehU 0S1AgvYLbeed//XGNbve8ev4nwLWTsoRXBBTi4cga53cnbbCwLAEa6kvenI+m7PB C/RoeXId3rAxmk5Rn20axRkKDNeVzBKXpzY5luG8BP6e0X0nmRnv7n/NJZDO8JS8 S3mRKySuZEsGOd/B2+ZL8+IDniwIoVXBeJ3gXhAhe3tFv2Y19C1Hmo+YkBzEdJM1 3D3jA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; bh=EMz4i2+GN3cuAUY818q72KeTEkZFkjcX3PB7nB+6/ O0=; b=VD0IbPn2D3jnDE3t1weobujr9hwhiaGgZys8hKCWiwsDEhpnXRmteILwR yrwaOTK6O/xD77880oysi+0h5LPJ4LWDJEGXBQ2lQRpBTFx4WvCSoaKLpJNKzxbP MqioFqpxNQyH4y/AVYgwTtliPlOiLbQFm5w7BVD+2ZquSoCCIV2rec58UrfXXdUb EmPWT//OvE9xJBxrYNJMBrbKrp3j+jLl8E/+wFST8GeMVKoWJnFWpgtW5VG5MLFH n7DfhUkJL4BQnByCHQtNjkLEnh9D6S7X4CRC80mebe+LA2pps0deNCZPtUO/ak2b cxJkmzsgAKvYrLJBMbjqHvsZLN1HA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrtddtgdeivdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenog fuuhhsphgvtghtffhomhgrihhnucdlgeelmdenucfjughrpefuvfhfhffkffgfgggjtgfg sehtkeertddtfeejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirg hnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuffhomhgrihhnpehgihhthhhu sgdrihhonecukfhppeejhedrudejvddrledtrdelvdenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhl rghvvghrrdgtohhm X-ME-Proxy: Received: from [192.168.1.10] (75-172-90-92.tukw.qwest.net [75.172.90.92]) by mail.messagingengine.com (Postfix) with ESMTPA id 45124328005E; Tue, 31 Mar 2020 11:54:47 -0400 (EDT) Subject: Re: migrate off oracle data to postgres To: Pepe TD Vo , Pgsql-admin , Pgsql-general , PgAdmin Support List , JC JC References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com> <1587437647.1103378.1585664119295@mail.yahoo.com> <1493124385.1141236.1585669895986@mail.yahoo.com> From: Adrian Klaver Message-ID: Date: Tue, 31 Mar 2020 08:54:46 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.6.0 MIME-Version: 1.0 In-Reply-To: <1493124385.1141236.1585669895986@mail.yahoo.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/31/20 8:51 AM, Pepe TD Vo wrote: > I have tables ddl data definitions already.  Only need to move the data > over off Oracle to Postgres PostgreSQL Foreign Data Wrapper for Oracle: http://laurenz.github.io/oracle_fdw/ -- Adrian Klaver adrian.klaver@aklaver.com