Re: SQL*Loader and Stream Record Format

Grow up Rob. Get married. Get some kids and lecture them.

Regards.
Oran

On Mon, 26 Dec 2005 15:32:06 -0500, Rob Zijlstra <rj.zijlstra@xxxxxxxxxx> wrote:

On Mon, 26 Dec 2005 14:41:58 -0500, "oran johnson"
<mobileoran@xxxxxxxxxxxxx> wrote:

Can I access an internet file (http://www.sometime.com/file.txt) via
slq*loader?

Thanks
Oran


On Sat, 24 Dec 2005 12:26:08 -0500, Frank van Bortel
<frank.van.bortel@xxxxxxxxx> wrote:

oran johnson wrote:
I have recently downloaded, installed and created a database using
Oracle Database 10g Express Edition Beta 2 Release for Microsoft
Windows. My table was created and loaded using the load text data
option on the Database Home Page. I would like to automate the update
process using the SQL*Loader. I hava a text file that contains a 129
comma delimited fields per line. I am only interested in fields 1-17.
How do I advance the SQL*Loader to the next line after the 17th field?

Thanks.
Oran


Define the rest as a filler; look up the filler keyword
in the Utilities Manual



Do NOT toppost.

BEFORE asking, start with something like
http://www.oracle.com/technology/products/database/utilities/htdocs/sql_loader_overview.html.

THEN Google.

THEN try your solution YOURSELF.

After that -when not working- state ora version etc etc, everything
YOU YOURSELF tried and then I know that you did something YOURSELF
before you started to ask.

Have a nice day.

Might be a bit harsh, but I'm gettinmg s.a.t. from thew level of
questions lately,

Best Regards

Rob Zijlstra 



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
.

Relevant Pages

  • Re: Slow windows xp startup
    ... >>> conflicts when you start Microsoft Windows XP. ... >>> to restore your system from a clean boot state. ... >>> File, Process WIn.ini File, and Load Startup Items check boxes. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Slow windows xp startup
    ... do you know how/have tried to boot into safemode? ... >> here is a copy of the Microsoft KB article for a clean boot in winxp: ... >> conflicts when you start Microsoft Windows XP. ... >> File, Process WIn.ini File, and Load Startup Items check boxes. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Multiple Stop Errors
    ... Microsoft Certified Professional ... Microsoft MVP [Windows] ... | Often times when I turn on my desktop, Windows begins to load and the ... computer simply reboots itself during the splash screen. ...
    (microsoft.public.win2000.setup)
  • Re: wishlist
    ... Including all the non-Microsoft programs for which Microsoft has no ... You do realize that any such web-based lookup help would result in ... start the game will load another program because the first one is part ... Windows load time) and it is the driver that does the work, ...
    (microsoft.public.windowsxp.general)
  • Re: Some questions
    ... Open WMP 6.4 and goto View>>Options>>Formats ... Not sure, WMP nor Windows will load the file before you double click, ... Microsoft to users of the software who take their time to help others. ...
    (microsoft.public.windowsmedia.player)