Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Tool to load data
If your on a MicroSlop OS try Winbatch (www.winbatch.com).
Dick Goulet
____________________Reply Separator____________________ Author: "Nguyen; David M" <david.m.nguyen_at_xo.com> Date: 10/2/2002 9:44 AM
Hi all,
I'd like to know if there is some tool we can use to automate loading data into database using SQLLDR either via GUI or scripts. I need to allow someone to login the system to bulk load data without worrying he destroys database. Any advices will be appreciated.
Regards,
David
<!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" xmlns:st1 = "urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META content=Word.Document name=ProgId>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR>
<META content="Microsoft Word 10" name=Originator><LINK
href="cid:filelist.xml_at_01C26A37.E91AABE0" rel=File-List><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"></o:SmartTagType><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel></w:WordDocument>
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
P.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt;
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family:
"Times New Roman"; mso-believe-normal-left: yes
}
LI.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt;
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family:
"Times New Roman"; mso-believe-normal-left: yes
}
DIV.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt;
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family:
"Times New Roman"; mso-believe-normal-left: yes
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.EmailStyle17 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply;
mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial
mso-style-name: ""; mso-spl-e: yes
}
SPAN.GramE {
mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";}
{margin-left:1.5pt;}
</style>
<![endif]></HEAD>
<BODY bgColor=#ffffff lang=EN-US link=blue
style="MARGIN-LEFT: 1.5pt; MARGIN-TOP: 1.5pt; tab-interval: 36.0pt"
vLink=purple>
<DIV><SPAN class=715033316-02102002>Hi all,</SPAN></DIV>
<DIV><SPAN class=715033316-02102002></SPAN> </DIV>
<DIV><SPAN class=715033316-02102002>I'd like to know if there is some tool we
can use to automate loading data into database using SQLLDR either via GUI or
scripts. I need to allow someone to login the system to bulk load
data without worrying he destroys database. Any advices will be
appreciated.</SPAN></DIV>
<DIV><SPAN class=715033316-02102002></SPAN> </DIV>
<DIV><SPAN class=715033316-02102002>Regards,<BR>David</SPAN></DIV></BODY></HTML>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Oct 02 2002 - 13:58:24 CDT