Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:Tool to load data

Re:Tool to load data

From: <dgoulet_at_vicr.com>
Date: Wed, 02 Oct 2002 10:58:24 -0800
Message-ID: <F001.004DE81E.20021002105824@fatcity.com>


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 HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<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>
</xml><![endif]--><!--[if !mso]>
<STYLE>st1\:* {

        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

}
SPAN.SpellE {

        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";}

</style>
<![endif]--><![if mso 9]>
<style>

p.MsoNormal

        {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>&nbsp;</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.&nbsp; I need to allow someone to login&nbsp;the system to bulk load data without worrying he destroys database.&nbsp; Any advices will be appreciated.</SPAN></DIV>
<DIV><SPAN class=715033316-02102002></SPAN>&nbsp;</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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US