Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: direct =y in export statement
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0437E.62007570
Content-Type: text/plain
thanx for all who contributed, i got a good picture now!
thanx once again...
Swapna_P_at_satyam.com
Extn : 5603/5648
> ---------- > From: Sunil_Nookala_at_Dell.com[SMTP:Sunil_Nookala_at_Dell.com] > Reply To: ORACLE-L_at_fatcity.com > Sent: Wednesday, November 01, 2000 2:29 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: direct =y in export statement > > Swapna, > please refer to Oracle 8 utilities manual part 1. > "To use Direct path export specify the DIRECT=Y parameter on the command > line or parameter file. > It indicates that it is a DIRECT path export (not CONVENTIONAL). > Direct path export extracts data much faster than conventional path > export. > Direct path export achieves this performance gain by reading data > directly, bypassing the SQL command processing layer and saves > on data copies whenever possible." > > Sunil Nookala > Dell Computer Corporation > Austin, TX > > -----Original Message----- > From: Swapna_P [mailto:Swapna_P_at_satyam.com] > Sent: Tuesday, October 31, 2000 1:21 PM > To: Multiple recipients of list ORACLE-L > Subject: direct =y in export statement > > > > what does this indicate? > what is its significance? > >
------_=_NextPart_001_01C0437E.62007570
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: direct =3Dy in export statement</TITLE>
</HEAD>
<BODY>
<P><FONT COLOR=3D"#000080" FACE=3D"Arial">thanx for all who =
contributed, i got a good picture now!</FONT>
<BR><FONT COLOR=3D"#000080" FACE=3D"Arial">thanx once again...</FONT>
<BR><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Comic Sans =
MS">Swapna_P_at_satyam.com </FONT>
<BR><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Comic Sans MS">Extn : =
5603/5648</FONT>
</P>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans =
Serif">Sunil_Nookala_at_Dell.com[SMTP:Sunil_Nookala_at_Dell.com]</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Reply To:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans =
Serif">ORACLE-L_at_fatcity.com</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Sent:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Wednesday, November 01, 2000 2:29 =
AM</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">To:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Multiple =
recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Subject:</FONT></B> =
<FONT SIZE=3D1 FACE=3D"MS Sans =
Serif">RE: direct =3Dy in export statement</FONT>
</P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Swapna,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">please refer to =
Oracle 8 utilities manual part 1.</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">"To use Direct =
path export specify the DIRECT=3DY parameter on the command line or =
parameter file.</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">It indicates that =
it is a DIRECT path export (not CONVENTIONAL).</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Direct path export =
extracts data much faster than conventional path export.</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Direct path export =
achieves this performance gain by reading data directly, bypassing =
the=A0SQL command processing layer and saves</FONT> </P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">on data copies =
whenever possible."</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Sunil =
Nookala</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Dell Computer =
Corporation</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Austin, TX</FONT>
</P>
<UL>
<P><FONT SIZE=3D2 FACE=3D"Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D2 FACE=3D"Tahoma">From:</FONT></B><FONT SIZE=3D2 =
FACE=3D"Tahoma"> Swapna_P [</FONT><U><FONT COLOR=3D"#0000FF" SIZE=3D2 = FACE=3D"Tahoma"><A = HREF=3D"mailto:Swapna_P_at_satyam.com">mailto:Swapna_P_at_satyam.com</A></FONT=></U><FONT SIZE=3D2 FACE=3D"Tahoma">]</FONT>
<P><FONT COLOR=3D"#000080" FACE=3D"Arial">what does this =
indicate?</FONT><FONT FACE=3D"Arial"> </FONT>
<BR><FONT COLOR=3D"#000080" FACE=3D"Arial">what is its =
Received on Tue Oct 31 2000 - 15:06:06 CST