Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
255 character limit with SQLLoader
- Thread starter rasprer
- Start date
SantaMufasa
Technical User
Rasprer,
When situations like this occur, I just use a text editor to globally modify my incoming text file into valid SQL INSERT statements. Could that work for you?
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
When situations like this occur, I just use a text editor to globally modify my incoming text file into valid SQL INSERT statements. Could that work for you?
Mufasa(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
Just specipy the actual (or greater length):
![[bigglasses]](/data/assets/smilies/bigglasses.gif "[bigglasses] [bigglasses]")
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Code:
LOAD DATA...
(COL1 CHAR(2000),... )----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
- Status
Similar threads
