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 <pgadmin-support-owner+archive@lists.postgresql.org>)
	id 1jJHzQ-0008Rx-Jy
	for pgadmin-support@arkaria.postgresql.org; Tue, 31 Mar 2020 14:35:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgadmin-support-owner+archive@lists.postgresql.org>)
	id 1jJHzP-0004BR-H7
	for pgadmin-support@arkaria.postgresql.org; Tue, 31 Mar 2020 14:35:39 +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 <jan.g.birk@gmail.com>)
	id 1jJHzP-00049i-7F
	for pgadmin-support@lists.postgresql.org; Tue, 31 Mar 2020 14:35:39 +0000
Received: from mail-lj1-x235.google.com ([2a00:1450:4864:20::235])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <jan.g.birk@gmail.com>)
	id 1jJHzJ-0003E0-12
	for pgadmin-support@lists.postgresql.org; Tue, 31 Mar 2020 14:35:38 +0000
Received: by mail-lj1-x235.google.com with SMTP id r7so14537445ljg.13
        for <pgadmin-support@lists.postgresql.org>;
 Tue, 31 Mar 2020 07:35:32 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=message-id:subject:from:to:date:in-reply-to:references:user-agent
         :mime-version;
        bh=aowaPnK1DIYu83TiunEeJPPK8jCPsEomkixpfnLmHZw=;
        b=DoSXr8eyVD3cE+kJ2UPys95T6nfScOff1tq1hnO64P92m3xQmgYbOHeXVNM+v9aVo5
         rehTyyJFWumOzSafyUIEKYZw+iTF249KT2xhKYZ7DoN2Lj/fl+pad0GvtIAUvIi5rNUx
         kQhw0BHqQcuZGeMrEElTU2iPueddtx44NMWEY6r/+1WhHXkIAb1k1Q7JWNuOjGaT5vCM
         +J3qTULRJdU4SgvRCLVMbVl34myFmylcq/O99v1WoX4Myg8AKqxdLCUSaA1NC29nhl6g
         e+BTNFRyeiCiZ4bWuIN66knZ16dNyee2rHGL4AOhqc2nD/f0asqjPbY8q8VFPddupmnd
         Y4Ng==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to
         :references:user-agent:mime-version;
        bh=aowaPnK1DIYu83TiunEeJPPK8jCPsEomkixpfnLmHZw=;
        b=MDPq1qK+adD9eXd+UTJH2ONPjcIHdQN1+78djKH6ei3uOUFJMPGACjDT/Yq1pwS/k/
         BXo7nVlILRXDKrqthSnicPoa4L1t96/bn8WUjzxF/WfEzfunTLy1Xzbovco9xhYNGmEJ
         GUodfvz3mz31cy/Jf8lo5cHNMdL7pGR6PxPUGwBNFcHghNioqMObQFLZOyZnKGNuBStk
         leD6WmkB7ANqplj1KjTYGgXV7GfcNYZmtkF2usLKwBCp2mAWJYH2lJvNNfbakrNe7eIo
         W9giWNoB7slTCFoNk8FdCo6zEx23YMYiZwhc1AXYfb8bKSta4BNtONg4YjEk76zo51YZ
         NpGA==
X-Gm-Message-State: AGi0Puane9BdfSgNcGvFo87ii2CYevwumavaqdp6nUORKfyLbDBsFFCw
	Y6sAzkr/luCMn5jLX2y+qr9B31P9
X-Google-Smtp-Source: 
 APiQypLOamd+zBkW/ROpahNcwIFLneMEHEgzB/MmQX57ycq8PKPXnjosDp18+udV8yUK605gbTzWHQ==
X-Received: by 2002:a2e:9616:: with SMTP id v22mr8838160ljh.107.1585665330959;
        Tue, 31 Mar 2020 07:35:30 -0700 (PDT)
Received: from mobile.3.dk ([2a02:aa7:4602:d7aa:f4db:ae5a:4b05:3796])
        by smtp.googlemail.com with ESMTPSA id
 v12sm8709301ljh.6.2020.03.31.07.35.28
        for <pgadmin-support@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Tue, 31 Mar 2020 07:35:29 -0700 (PDT)
Message-ID: <98efff404a8130d7ae0aa15c435cf80937c6784e.camel@gmail.com>
Subject: Re: migrate off oracle data to postgres
From: Jan Birk <jan.g.birk@gmail.com>
To: pgadmin-support@lists.postgresql.org
Date: Tue, 31 Mar 2020 16:35:27 +0200
In-Reply-To: <1587437647.1103378.1585664119295@mail.yahoo.com>
References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com>
	 <1587437647.1103378.1585664119295@mail.yahoo.com>
Content-Type: multipart/alternative; boundary="=-Gh5d3AYlvlyRUxNgbasN"
User-Agent: Evolution 3.34.1-2 
MIME-Version: 1.0
List-Id: <pgadmin-support.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgadmin-support@lists.postgresql.org>
List-Owner: <mailto:pgadmin-support-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgadmin-support>
Precedence: bulk


--=-Gh5d3AYlvlyRUxNgbasN
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

tir, 31 03 2020 kl. 14:15 +0000, skrev Pepe TD Vo:
> 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?

How huge is huge?
We have used ora2pg for ~1tb with success

Best

/Jan



--=-Gh5d3AYlvlyRUxNgbasN
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html dir=3D"ltr"><head></head><body style=3D"text-align:left; direction:lt=
r;"><div>tir, 31 03 2020 kl. 14:15 +0000, skrev Pepe TD Vo:</div><blockquot=
e type=3D"cite" style=3D"margin:0 0 0 .8ex; border-left:2px #729fcf solid;p=
adding-left:1ex">I have a huge data on Oracle, would you please suggest how=
 to migrate all data off Oracle to Postgres?&nbsp; Do I ne<span>ed to expor=
t into csv and upload to postgres?&nbsp; Ora<span>2pg is limited data from =
oracle to postgresql right?</span></span></blockquote><div><br></div><div>H=
ow huge is huge?</div><div><br></div><div>We have used ora2pg for ~1tb with=
 success</div><div><br></div><div>Best</div><div><br></div><div>/Jan</div><=
div><br></div></body></html>

--=-Gh5d3AYlvlyRUxNgbasN--