OraFAQ Forum: Server Utilities » to accept the column which has newline character into the table using sql loader

Home » RDBMS Server » Server Utilities » to accept the column which has newline character into the table using sql loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

to accept the column which has newline character into the table using sql loader [message #190820]

Fri, 01 September 2006 07:23

deepti_07
Messages: 13
Registered: January 2006

Junior Member

Hi,

I have my input file as

362921|JUSTIN Master Servi|INSTALL|

362857|LAURA Master Service|INSTALL|

364141|SIMI
Master Service Call|INSTALL|

364199|KEAN
Master Service Call Nu|INSTALL|

364250|JERRY
Master Service|INSTALL|

As one can see that, the last three records have the second
column with an embedded newline character.

Can someone help me to build the sql control file such that it
will load the second column even if it has a newline character embedded?

Thanks in advance

Deepti

Report message to a moderator

Previous Topic:	Loading 3,500,000 records
Next Topic:	imp from 9i to 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:27:33 CST 2024