Priority: normal
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7FAEC.BFCD1CF3"
Subject: RE: Migrating 3TB size database from HP to AIX, also 9i to 10g.
Date: Wed, 19 Sep 2007 11:41:54 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C4508B6E7A5@NT15.oneneck.corp>
In-Reply-To: <E02CB9B2777CF8459C86C49B48C48EC6024B6058@exchange.bjss.co.uk>
Thread-Topic: Migrating 3TB size database from HP to AIX, also 9i to 10g.
References: <97b7fd2f0709190343l3d74176bh2826189e57a7e50b@mail.gmail.com> <E02CB9B2777CF8459C86C49B48C48EC6024B6058@exchange.bjss.co.uk>
From: "Allen, Brandon" <Brandon.Allen@OneNeck.com>
To: <john.hallas@bjss.co.uk>,
 <sjaffarhussain@gmail.com>,
 <oracle-l@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: Brandon.Allen@OneNeck.com
------_=_NextPart_001_01C7FAEC.BFCD1CF3
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Just a word of caution - I haven't used datapump a lot, but the few
times I have used it I was very disappointed with its performance - it
took MUCH longer than good old exp/imp.  I don't have time to review my
notes right now and give you the specifics of exactly how I ran it with
my timings and all the bugs and tuning notes I found, but just be sure
to do some research first and beware that it's not necessarily true that
datapump speed > exp/imp speed so test it for your specific situation -
as usual, it depends.

Regards,
Brandon

________________________________

From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] On Behalf Of John Hallas


Once you get to 10g on HP you can use datapump which is much faster


Privileged/Confidential Information may be contained in this message or =
attachments hereto. Please advise immediately if you or your employer do =
not consent to Internet email for messages of this kind. Opinions, =
conclusions and other information in this message that do not relate to =
the official business of this company shall be understood as neither =
given nor endorsed by it.


------_=_NextPart_001_01C7FAEC.BFCD1CF3
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:st1 =3D=20
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16525" name=3DGENERATOR><!--[if !mso]>
<STYLE>v\:* {
	BEHAVIOR: url(#default#VML)
}
o\:* {
	BEHAVIOR: url(#default#VML)
}
w\:* {
	BEHAVIOR: url(#default#VML)
}
.shape {
	BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name=3D"PersonName"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><!--[if !mso]>
<STYLE>st1\:* {
	BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
	font-family: Tahoma;
}
@font-face {
	font-family: Comic Sans MS;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt =
90.0pt; }
P.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
	COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
	COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
	COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
	COLOR: blue; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
	FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: =
"Comic Sans MS"; TEXT-DECORATION: none; mso-style-type: personal-reply
}
DIV.Section1 {
	page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dblue link=3Dblue>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff =
size=3D2><SPAN=20
class=3D559193818-19092007>Just a word of caution - I haven't used =
datapump a lot,=20
but the few times I have used it I was very disappointed with its =
performance -=20
it took MUCH longer than good old exp/imp.&nbsp; I don't have time to =
review my=20
notes right now and give you the specifics of exactly how I ran it with =
my=20
timings&nbsp;and all the bugs and tuning notes I found, but just be sure =
to do=20
some research first and beware that it's not necessarily true that =
datapump=20
speed &gt; exp/imp speed so test it for your specific situation - as =
usual, it=20
depends.<BR></SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff =
size=3D2><SPAN=20
class=3D559193818-19092007>Regards,</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff =
size=3D2><SPAN=20
class=3D559193818-19092007>Brandon</DIV></SPAN></FONT><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> oracle-l-bounce@freelists.org=20
[mailto:oracle-l-bounce@freelists.org] <B>On Behalf Of </B>John=20
Hallas<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3D"Comic Sans MS" color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Comic Sans =
MS'">Once you get=20
to 10g on HP you can use datapump which is much=20
faster</SPAN></FONT></P></DIV></BODY><!--[object_id=3D#oneneck.com#]--><F=
ONT face=3DTahoma size=3D2><FONT color=3D#0000ff>
<P>Privileged/Confidential Information may be contained in this message =
or attachments hereto. Please advise immediately if you or your employer =
do not consent to Internet email for messages of this kind. Opinions, =
conclusions and other information in this message that do not relate to =
the official business of this company shall be understood as neither =
given nor endorsed by it.</P></FONT></FONT></HTML>

------_=_NextPart_001_01C7FAEC.BFCD1CF3--
--
http://www.freelists.org/webpage/oracle-l