Date: Tue, 3 Mar 2020 17:32:57 +0000 (UTC)
From: "Sanjay Mishra" <dmarc-noreply@freelists.org> (Redacted sender
 "smishra_97" for DMARC)
To: Oracle-L Freelists <oracle-l@freelists.org>
Message-ID: <1194648278.5353538.1583256777312@mail.yahoo.com>
Subject: Copy Big Table from one Db to another
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----=_Part_5353537_976633975.1583256777311"
References: <1194648278.5353538.1583256777312.ref@mail.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: dmarc-noreply@freelists.org
------=_Part_5353537_976633975.1583256777311
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Did anyone has done any benchmark and has created any details on the best m=
ethod 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 diffe=
rent databases share the same ASM disk group. Some options like=C2=A01. exp=
dp/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 initializat=
ion parameter setting like increasing PGA for Direct operation or tweak tha=
t can save the time
TIASanjay
------=_Part_5353537_976633975.1583256777311
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"yahoo-style-wrap" style=3D"font-fami=
ly:courier new, courier, monaco, monospace, sans-serif;font-size:13px;"><di=
v dir=3D"ltr" data-setdir=3D"false">Did anyone has done any benchmark and h=
as created any details on the best method to copy a big table from one DB t=
o 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&nbsp;</div><div dir=3D"ltr" data-setdir=3D"false">=
1. expdp/impdp - with optimization like parallel or so</div><div dir=3D"ltr=
" data-setdir=3D"false">2. Using DB Link and Insert Append</div><div dir=3D=
"ltr" data-setdir=3D"false">3. Using Copy command</div><div dir=3D"ltr" dat=
a-setdir=3D"false">4. Using sqlcl or other Oracle tool</div><div dir=3D"ltr=
" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">Ta=
bles have multiple LOBs object and it is not partitioned. Any initializatio=
n parameter setting like increasing PGA for Direct operation or tweak that =
can save the time</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><di=
v dir=3D"ltr" data-setdir=3D"false">TIA</div><div dir=3D"ltr" data-setdir=
=3D"false">Sanjay</div></div></body></html>
------=_Part_5353537_976633975.1583256777311--
--
http://www.freelists.org/webpage/oracle-l