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 1jQW0g-0004dg-B5 for pgsql-admin@arkaria.postgresql.org; Mon, 20 Apr 2020 12:58:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jQW0d-0003eH-MC for pgsql-admin@arkaria.postgresql.org; Mon, 20 Apr 2020 12:58:47 +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 1jQW0d-0003eA-Bd for pgsql-admin@lists.postgresql.org; Mon, 20 Apr 2020 12:58:47 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jQW0Z-0000Ro-Gv for pgsql-admin@lists.postgresql.org; Mon, 20 Apr 2020 12:58:46 +0000 Received: by mail-ot1-x32f.google.com with SMTP id q9so1315913otf.5 for ; Mon, 20 Apr 2020 05:58:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=CW6+wf+iz5CQLDm7VidJCnoD/WHXa18JAHzQ9GfGsps=; b=cCh3q6ZU0vGx+SytX9vJpQhDqzAbIL+Hb6okVuQl3US8zX9LWPJHmwyaXuXl+pC7Zw C4vf8+jYJjixpiQf2QaMV8PGXxbvzbW+82CW6FRSraIM2QHbVUODxs+M07KsYw19phvO toCh/U+c/Qve5gtBVRRId85h++XCXJUFpBaZUNPDZz6mTvPMr4+oM8QbnanehTyaxs6m 68FkUqNlH2VOmY1b1/VfF80h3Ess/s2fG0Sp41nfAxhGqoadWgTcYiKLfvT+Uhqa3rNp USKFjTv83DBE/azq4jKTCtlmsXSVzm6sek2Dtmiskx4Tl//Z4OJtyOEm+DovvbRFWIut hxLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=CW6+wf+iz5CQLDm7VidJCnoD/WHXa18JAHzQ9GfGsps=; b=CKPr/A4/6a6qUUpTJEedtJDfa/64kSqDD0JmlHnSYQyHlH/fElIMfohM1K9p8LEbQI 04HCh3be7vE6vIE//pgBKTcw1IsacpcxU/UYucqYjD6IAMGiZVWLz3Lv7VDv2SFeUExX GXVxvTquaLA1IeZVoEGqX6zaQEJjo6sLEsFNUvMij0IIGnW8z7C3tmlFoEbaTH4/ifzC xfIO1eJ1fKM56pWkTSk369Xstr9Y+lD7engkwa2+IfJzIgrlAgiPLSZFvMaMauPPCvYc H7bVaZ7ueVKoLcK4G2zw9wmwfHSAKw4fQe+4oVz7wePKIj2n+CJA6W3YG60QnjriDMOc 5z6w== X-Gm-Message-State: AGi0PuZnmNyozLMBuTbUFAUca0bt8W1PhbZ71Ail+nLva0GcUR9ImI8u 7yZxNj4z0WUPf7M/KHOm2sdaZN9vBjw= X-Google-Smtp-Source: APiQypKBuRVKXTee9/kVyd4rMoHc5hP+Tjb/0MdopWwm3CfXhlPG+sruBgsh1G7me6hWuhtlABdn4g== X-Received: by 2002:a9d:8e9:: with SMTP id 96mr9517465otf.241.1587387522490; Mon, 20 Apr 2020 05:58:42 -0700 (PDT) Received: from [192.168.1.10] (ip70-186-126-197.no.no.cox.net. [70.186.126.197]) by smtp.googlemail.com with ESMTPSA id k16sm177542otb.5.2020.04.20.05.58.41 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 20 Apr 2020 05:58:41 -0700 (PDT) Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: Date: Mon, 20 Apr 2020 07:58:40 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 4/20/20 6:53 AM, Prashant Kulkarni wrote: > Hi Team, > > Please can you let me know the menthds/tools/approches to export large > amount of data (TBs) present in the schemas into the CSV/delimated format > as we have to import that into PostgreSQL later. > > I tried for options like SQL Developer/Toad but those are not feasible for > vast data size, these tool are OK for GBs of data to export. > > Kindly let me know if you have any solution to complete this task. What kind of data (transaction history, binary blobs, GIS, etc)? -- Angular momentum makes the world go 'round.