Home » RDBMS Server » Server Utilities » SQL*LOADER - Selectively Load Data File
SQL*LOADER - Selectively Load Data File [message #72379] Mon, 02 June 2003 10:57 Go to next message
Phil Paxman
Messages: 4
Registered: August 2002
Junior Member
I have a problem which I need help with. I am writing a script to laod a deliminated txt file. The problem is that the input fields and record length can can change based on conditions at the time of extract. The files are named the same.

How can I determine which format to load? Is there a way of selectively loading based on fields in the txt file.

Thanks

phil

Report message to a moderator

Re: SQL*LOADER - Selectively Load Data File [message #72383 is a reply to message #72379] Mon, 02 June 2003 17:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are u inserting into the same table?
then have the column size as max.

Report message to a moderator

Re: SQL*LOADER - Selectively Load Data File [message #72386 is a reply to message #72383] Tue, 03 June 2003 07:27 Go to previous message
Phil
Messages: 32
Registered: March 2001
Member
Thanks for you reply but I think you misunderstood. Increasing column size does not help me with my problem.

Report message to a moderator

Previous Topic: export
Next Topic: Export Parameter (buffer)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 08 20:06:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.