Copy Big Table from one Db to another

From: Sanjay Mishra <"Sanjay>
Date: Tue, 3 Mar 2020 17:32:57 +0000 (UTC)
Message-ID: <1194648278.5353538.1583256777312_at_mail.yahoo.com>



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 so2. Using DB Link and Insert Append3. Using Copy command4. 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 TIASanjay

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 03 2020 - 18:32:57 CET

Original text of this message