Re: Copy Big Table from one Db to another
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 3 Mar 2020 17:42:44 +0000
Message-ID: <LNXP265MB15625045A0FF3612BB3B3263A5E40_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: 03 March 2020 17:32
To: Oracle-L Freelists
Subject: Copy Big Table from one Db to another
Date: Tue, 3 Mar 2020 17:42:44 +0000
Message-ID: <LNXP265MB15625045A0FF3612BB3B3263A5E40_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>
Any scope for using transportable tablespaces ? Even if you have to transport more than you want then drop the excess objects after the tablespace(s) arrive.
Regards
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: 03 March 2020 17:32
To: Oracle-L Freelists
Subject: Copy Big Table from one Db to another
Did anyone has done any benchmark and has created any details on the best method to copy a big table from one DB to another. I am looking for a 2-5 Tb tables to be moved within the same ASM storage or can say that these different databases share the same ASM disk group. Some options like
1. expdp/impdp - with optimization like parallel or so 2. Using DB Link and Insert Append 3. Using Copy command 4. Using sqlcl or other Oracle tool
Tables have multiple LOBs object and it is not partitioned. Any initialization parameter setting like increasing PGA for Direct operation or tweak that can save the time
TIA
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 03 2020 - 18:42:44 CET