Home » RDBMS Server » Server Utilities » "\n" in datafile causing problems
"\n" in datafile causing problems [message #368143] Thu, 07 September 2000 11:02
Bernard T.
Messages: 1
Registered: September 2000
Junior Member
I'm migrating from Ingres to Oracle 8.1.6 DBMS, when using SQL Loader to load data into Oracle tables, I get an error:

ORA-01401: inserted value too large for column

for records that contain the "\n" character (sans quotes). The data in question are all CHAR datatypes within the maximum length limits. Does anyone know any way around this? Prefer handle fix in control file.
Previous Topic: EnterManager
Next Topic: Updating fields with SQL Loader
Goto Forum:

Current Time: Fri Jun 09 17:39:08 CDT 2023