Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Sql * Loader

Re: Sql * Loader

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 17 Apr 2006 15:08:50 +0200
Message-ID: <44439363$0$13238$636a55ce@news.free.fr>

<gls.kiranmayi_at_gmail.com> a écrit dans le message de news: 1145274678.488027.183920_at_t31g2000cwb.googlegroups.com...
|I have problem loading data
| for example with delimited data
|
| Data such as
|
| Nancy|San Jose|US
|
| is loaded successfully but if I use multiple termination characters
| such as '**' below
|
| Nancy**San Jose**US
|
| and specify in the control file , TERMINATED BY '**'
| I got the error message saying 'Expecting one char when found
| multiple'
| The error number is : 350.
|
|
|
| Can't we use mulitple chars as termination character
|
| Thanks,
|

No.

Regards
Michel Cadot Received on Mon Apr 17 2006 - 08:08:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US