| SQL LOADER [message #491072] |
Fri, 28 January 2011 22:47  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi All,
Can any one tell me the reason "why sql loader's CONTROL FILE is not working, if that location has space in between"
Eg - C:\practice for sqlloader\control1.ctl
But it works if we remove the space in between the path as below:
Eg - C:\practice_for_sqlloader\control1.ctl
Regards:
Muktha
|
|
|
|
|
|
|
|
| Re: SQL LOADER [message #492344 is a reply to message #491074] |
Sat, 29 January 2011 14:09  |
 |
Barbara Boehmer
Messages: 9058
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
You can also place the complete file name and path within single quotes:
'C:\practice for sqlloader\control1.ctl'
or use the path that you can see when you do dir/x from the sql command window, which is the first six characters followed by a tilde followed by a number (if there are multiple folders with the same first 6 characters, then windows numbers them sequentially):
C:\practi~1\control1.ctl
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
