|
-
Just throwing in my 2 cents. I saved this but I'm unsure where I found it. This may help you also.
December's Tip of the Month
Using SQL*Loader to Load Tab-delimited Files
Tip supplied by: Eva Blinder ([email protected])
The trick is that the tab delimiter has to be specified in hexadecimal format, and SQL*Loader is very picky about the syntax. Here is an example of the control file you would create to specify a delimiter of tab:
LOAD DATA
INFILE 'FILENAME.TXT'
INTO TABLE t1
FIELDS DELIMITED BY x'09'
TRAILING NULLCOLS
( column 1....
)
Good luck,
Joe
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|