Home » RDBMS Server » Server Utilities » Re: Varchar2 over 255 bytes using SQL*Loader
Re: Varchar2 over 255 bytes using SQL*Loader [message #367977] Fri, 13 August 1999 10:58
declan
Messages: 3
Registered: August 1999
Junior Member
Apparently anything over 250 characters you have to tell sql*loader the max size
of your column.
So in your control file you need to amend the list of columns i.e.
(col1, col2, col3)
becomes
(col1, col2 CHAR(2000),col3)

Report message to a moderator

Previous Topic: Re: How does one export an Oracle table to a Comma Delimited Flat File
Next Topic: Re: Sql-Loader Date Format - Solution
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 30 03:49:45 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.