Glenn,
At the last NorthEast Oracle Users Group meeting we had a developer from
Oracle in Nashua NH who's purpose in life is the utilities like SQL*Loader,
Export and Import. He told us of the "replacement of SQL*Loader" in Oracle 9.
Basically you've hit it on the head. You place the file somewhere where the DB
can see it and using SQL*Loader like syntax describe the table(s) to the
database. Then you can use plain old SQL to either read and process the data or
manipulate it as you like. I believe he said we could even index the data
therein and that it could be used for either data extraction and insertion.
Sounds interesting, can't wait to get my hands on it.
Dick Goulet
____________________Reply Separator____________________
Author: Glenn Travis <[EMAIL PROTECTED]>
Date: 5/22/2001 7:16 AM
apologies. no offense was intended.
on a side note, Informix has a feature that lets you define a table which
references a flat file in unix. This allows them to bypass the buffer cache
and facilitate fast table loads. I believe I read that this will be in
Oracle 9 also, but I can't find the references at this time. Anyone have
more info?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle,
William T (Bill), NLCIO
Sent: Monday, May 21, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulkcopy
AT&T uses Oracle. I'm well acquainted with sqlldr, and I assumed that the
questioner was too. I took his question to be: was there a bulkcopy utility
in addition to sqlldr and the answer as far as I know is no.
Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]
-----Original Message-----
From: Glenn Travis [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulkcopy
sqlldr. AT&T obviously uses Sybase.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle,
William T (Bill), NLCIO
Sent: Monday, May 21, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bulkcopy
Howdy,
The only bulkcopy utility that I know of is a Sybase utility. The
Sybase bcp command moves data from a flat file to a Sybase table and vice
versa. I don't know of any such command in Oracle.
Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]
-----Original Message-----
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Bulkcopy
All,
Anyone heard of this utility for Oracle ?. Someone mentioned it today and
I didn't have a clue. They said it would be in $ORACLE_HOME/bin. Nothing
there !!
Regards
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40"; xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content=Word.Document name=ProgId>
<META content="MSHTML 5.00.3314.2100" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK
href="cid:[EMAIL PROTECTED]"; rel=File-List><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
font-family: Impact;
}
@font-face {
font-family: Century Gothic;
}
@font-face {
font-family: Tahoma;
}
P.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt;
mso-fareast-font-family: "Times New Roman"; mso-style-parent: "";
mso-pagination: widow-orphan
}
LI.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt;
mso-fareast-font-family: "Times New Roman"; mso-style-parent: "";
mso-pagination: widow-orphan
}
DIV.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt;
mso-fareast-font-family: "Times New Roman"; mso-style-parent: "";
mso-pagination: widow-orphan
}
P.MsoAutoSig {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt;
mso-fareast-font-family: "Times New Roman"; mso-pagination: widow-orphan
}
LI.MsoAutoSig {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt;
mso-fareast-font-family: "Times New Roman"; mso-pagination: widow-orphan
}
DIV.MsoAutoSig {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt;
mso-fareast-font-family: "Times New Roman"; mso-pagination: widow-orphan
}
P {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN-LEFT: 0in;
MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-fareast-font-family: "Times New
Roman"; mso-pagination: widow-orphan; mso-margin-bottom-alt: auto
}
CODE {
mso-fareast-font-family: "Courier New"; mso-ascii-font-family: "Courier
New"; mso-hansi-font-family: "Courier New"; mso-bidi-font-family: "Courier New"
}
SPAN.EmailStyle18 {
COLOR: navy; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial;
mso-hansi-font-family: Arial; mso-bidi-font-family: Arial; mso-style-type:
personal
}
SPAN.EmailStyle19 {
COLOR: #993366; mso-ansi-font-size: 10.0pt; mso-ascii-font-family:
Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;
mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US style="tab-interval: .5in">
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=400281417-22052001>apologies. no offense was
intended.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=400281417-22052001></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=400281417-22052001>on a
side note, Informix has a feature that lets you define a table which references
a flat file in unix. This allows them to bypass the buffer cache and
facilitate fast table loads. I believe I read that this will be in Oracle
9 also, but I can't find the references at this time. Anyone have more
info?</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]<B>On Behalf Of</B> Carle, William T (Bill),
NLCIO<BR><B>Sent:</B> Monday, May 21, 2001 12:45 PM<BR><B>To:</B> Multiple
recipients of list ORACLE-L<BR><B>Subject:</B> RE:
Bulkcopy<BR><BR></DIV></FONT>
<DIV class=Section1>
<P class=MsoNormal><SPAN class=EmailStyle19><FONT color=#993366 face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size:
12.0pt">AT&T
uses Oracle. I’m well acquainted with sqlldr, and I assumed that the
questioner was too. I took his question to be: was there a bulkcopy utility in
addition to sqlldr and the answer as far as I know is
no.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><SPAN class=EmailStyle19><FONT color=#993366 face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if
!supportEmptyParas]> <![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal><!--[if supportFields]><span class=EmailStyle19><font
size=2 color="#993366" face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style='mso-element:field-begin'></span><span
style="mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail
Signature" <span
style='mso-element:field-separator'></span></span></font></span><![endif]--><I><
FONT
color=#339966 face=Impact><SPAN
style="COLOR: #339966; FONT-FAMILY: Impact; FONT-STYLE:
italic"><o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT color=#339966 face=Impact size=3><SPAN
style="COLOR: #339966; FONT-FAMILY: Impact; FONT-SIZE: 12pt; FONT-STYLE:
italic">Bill
Carle<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal><FONT color=#993366 face="Century Gothic" size=3><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE:
12pt">AT&T</SPAN></FONT><FONT
color=#993366 face="Century Gothic"><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT color=#993366 face="Century Gothic" size=3><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE:
12pt">Database
Administrator</SPAN></FONT><FONT color=#993366 face="Century Gothic"><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT color=#993366 face="Century Gothic" size=3><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE:
12pt">816-995-3922</SPAN></FONT><FONT
color=#993366 face="Century Gothic"><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT color=#993366 face="Century Gothic" size=3><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; FONT-SIZE:
12pt">[EMAIL PROTECTED]</SPAN></FONT><FONT
color=#993366 face="Century Gothic"><SPAN
style="COLOR: #993366; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><!--[if supportFields]><span class=EmailStyle19><font
size=2 color="#993366" face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span
style='mso-element:field-end'></span></span></font></span><![endif]--><SPAN
class=EmailStyle19><FONT color=#993366 face=Arial size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if
!supportEmptyParas]> <![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=black face=Tahoma
size=2><SPAN
style="COLOR: black; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Glenn
Travis [mailto:[EMAIL PROTECTED]]<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, May 21, 2001 2:20
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Multiple recipients of
list ORACLE-L<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
Bulkcopy</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><![if
!supportEmptyParas]> <![endif]><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue face=Arial
size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt">sqlldr.
AT&T obviously uses Sybase.</SPAN></FONT><FONT color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT color=blue face=Arial
size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE:
10pt"> </SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in;
mso-margin-top-alt: 0in"><FONT
color=black face="Times New Roman" size=2><SPAN
style="COLOR: black; FONT-SIZE: 10pt"> -----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]<B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of</SPAN></B> Carle, William T (Bill),
NLCIO<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, May 21,
2001 11:46 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Multiple
recipients of list ORACLE-L<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Bulkcopy</SPAN></FONT><FONT
color=black size=2><SPAN
style="COLOR: black; FONT-SIZE: 10pt; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN class=EmailStyle18><FONT
color=navy face=Arial size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size:
12.0pt">Howdy,<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN class=EmailStyle18><FONT
color=navy face=Arial size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if
!supportEmptyParas]> <![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN class=EmailStyle18><FONT
color=navy face=Arial size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>The only bulkcopy utility
that I know of is a Sybase utility. The Sybase bcp command moves data from a
flat file to a Sybase table and vice versa. I don’t know of any such
command
in Oracle.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN class=EmailStyle18><FONT
color=navy face=Arial size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if
!supportEmptyParas]> <![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><!--[if supportFields]><span
class=EmailStyle18><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-begin'></span><span style="mso-spacerun: yes"> </span>AUTOTEXTLIST
\s "E-mail Signature" <span
style='mso-element:field-separator'></span></span></font></span><![endif]--><I><
FONT
color=#339966 face=Impact><SPAN
style="COLOR: #339966; FONT-FAMILY: Impact; FONT-STYLE:
italic"><o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><I><FONT color=#339966 face=Impact
size=3><SPAN
style="COLOR: #339966; FONT-FAMILY: Impact; FONT-SIZE: 12pt; FONT-STYLE:
italic">Bill
Carle<o:p></o:p></SPAN></FONT></I></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT color=navy
face="Century Gothic" size=3><SPAN
style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE:
12pt">AT&T</SPAN></FONT><FONT
color=black face="Century Gothic"><SPAN
style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT color=navy
face="Century Gothic" size=3><SPAN
style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE: 12pt">Database
Administrator</SPAN></FONT><FONT color=black face="Century Gothic"><SPAN
style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT color=navy
face="Century Gothic" size=3><SPAN
style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE:
12pt">816-995-3922</SPAN></FONT><FONT
color=black face="Century Gothic"><SPAN
style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT color=navy
face="Century Gothic" size=3><SPAN
style="COLOR: navy; FONT-FAMILY: 'Century Gothic'; FONT-SIZE:
12pt">[EMAIL PROTECTED]</SPAN></FONT><FONT
color=black face="Century Gothic"><SPAN
style="COLOR: black; FONT-FAMILY: 'Century Gothic'; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><!--[if supportFields]><span
class=EmailStyle18><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-end'></span></span></font></span><![endif]--><SPAN
class=EmailStyle18><FONT color=navy face=Arial size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><![if
!supportEmptyParas]> <![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black face=Tahoma
size=2><SPAN
style="COLOR: black; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Robertson
Lee - lerobe [mailto:[EMAIL PROTECTED]]<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, May 21, 2001 12:16
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Multiple recipients of
list ORACLE-L<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
Bulkcopy</SPAN></FONT><FONT color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black
face="Times New Roman" size=3><SPAN style="COLOR: black; FONT-SIZE:
12pt"><![if !supportEmptyParas]> <![endif]></SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black face=Arial
size=2><SPAN
style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE:
10pt">All,</SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> </SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black face=Arial
size=2><SPAN style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Anyone
heard of this utility for Oracle ?. Someone mentioned it today and I didn't
have a clue. They said it would be in $ORACLE_HOME/bin. Nothing there
!!</SPAN></FONT><FONT color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> </SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black face=Arial
size=2><SPAN
style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE:
10pt">Regards</SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> </SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black face=Arial
size=2><SPAN
style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE:
10pt">Lee</SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><!doctype HTML PUBLIC><FONT
color=black face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> </SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1.5in"><FONT color=black
face="Courier New" size=3><SPAN
style="COLOR: black; FONT-FAMILY: 'Courier New'; FONT-SIZE: 12pt;
mso-fareast-font-family: 'Courier New'"><BR><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">The information
contained in this communication is</SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">confidential,
is intended only for the use of the recipient</SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">named above,
and may be legally privileged. If the reader </SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">of this message
is not the intended recipient, you are</SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">hereby notified
that any dissemination, distribution or</SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">copying of this
communication is strictly prohibited. </SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">If you have
received this communication in error, please </SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">re-send this
communication to the sender and delete the </SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size: 12.0pt">original
message or any copy of it from your computer</SPAN></CODE><BR><CODE><SPAN
style="mso-bidi-font-size: 12.0pt; mso-ansi-font-size:
12.0pt">system.</SPAN></CODE></SPAN></FONT><FONT
color=black><SPAN
style="COLOR: black; mso-color-alt:
windowtext"><o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>
