| SQLLOADER Problem..... [message #51158] |
Fri, 03 May 2002 23:03  |
sahaslad
Messages: 23
Registered: May 2002
|
Junior Member |
|
|
Hi,
I am facing a mysterious problem
I am using sqlloader to load data from a file to the oracle database. I have done all the steps necessay for it like the ctl file, csv file, dat file and have gone through many examples from the different websites also. But still getting an err message like:
ERROR:
E:OracleOra81BIN>sqlldr userid=scott/tiger
control = ulcase1
SQL*Loader: Release 8.1.6.0.0 - Production on Sat May 4 12:14:10 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL*Loader-500: Unable to open file (ulcase1.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
I am not getting any hint as if why this is happening...
Any help....
SAHAS
|
|
|
|
|
|
| Re: SQLLOADER Problem. [message #63938 is a reply to message #51158] |
Sat, 27 November 2004 02:26  |
rishikesh
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
when u create a control file in a word document, save is as a .ctl , but when u save it give the filename "ulcase1.ctl" (i.e in inverted commas which is very important). If u dont useinverted commas then even if the file appears to be "ulcase1.ctl" it is actuallly a word document.
So dont forgfet to use the inverted commas in SAVE AS option for saving the file.
|
|
|
|
| Re: SQLLOADER Problem..... [message #117416 is a reply to message #51158] |
Wed, 27 April 2005 02:53 |
iamkay7
Messages: 1
Registered: April 2005
|
Junior Member |
|
|
Hi,
I had faced the same problem once while deploying the mappings in OWB. I was also at a loss to understand the message. But then I just tried recreating the mapping before deploying...and guess what ...the trick worked. I am not sure whether this solution is foolproof but there is no harm trying this option.
Thanks & Regards.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
