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)
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:
  


Current Time: Thu May 19 17:40:32 CDT 2022