Problem with SQL-Loader
Date: Mon, 29 Jan 2001 22:17:37 +0100
Message-ID: <954mp9$otk$04$1_at_news.t-online.com>
Hi,
[Quoted] I'm trying to import data from a large, comma seperated file using SQL-Loader. The file looks like this:
140,bmForm=search&bmFormID=954570676337&bmIsForm=true&bmPrevTemplate=main%2F [Quoted] cust_serv\.jhtml&bmHidden=SEARCH_INPUT%3C%3EobjectTypes&SEARCH_INPUT%3C%3Eob [Quoted] jectTypes=PRODUCT&bmHidden=SEARCH_INPUT%3C%3EobjectTypes&SEARCH_INPUT%3C%3Eo [Quoted] [Quoted] bjectTypes=SKU&bmHidden=SEARCH_I,..........
The database fields are varchar2(500) each.
It works fine if I import just the first field (in this record "140") but if [Quoted] [Quoted] I try it with second field it fails saying "Error -2 writing to badfile". It [Quoted] created an empty badfile in my home. I know that I have writing priviliges there.
[Quoted] [Quoted] Possibly the problem is caused by the special characters in the data. Does [Quoted] [Quoted] anyone have some experience with such import problems? Please help.
Nils Received on Mon Jan 29 2001 - 22:17:37 CET