Home » RDBMS Server » Server Utilities » SQL LOADER
SQL LOADER [message #208154] Fri, 08 December 2006 06:28 Go to next message
AnamCara
Messages: 3
Registered: December 2006
Location: Madrid, Spain
Junior Member
Hi guys

I am trying to load a file without extension, but I can not.
So, please could you tell me what I have to do if I want this?

The name of the data file is: /dirabc/dirxlm/e6o31
I write next into control file:
INFILE '/dirabc/dirxlm/e6o31'

but the sql loader give an error like this:
not found.

I look forward to hearing from you soon
Re: SQL LOADER [message #208158 is a reply to message #208154] Fri, 08 December 2006 06:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you don't specify an extension, then SQL*Loader will automatically look for the file named e6031.dat . Therefore, you may want to include a period after the filename in the control file (ie. INFILE '/dirabc/dirxlm/e6o31.').
Re: SQL LOADER [message #208201 is a reply to message #208158] Fri, 08 December 2006 09:59 Go to previous messageGo to next message
AnamCara
Messages: 3
Registered: December 2006
Location: Madrid, Spain
Junior Member
Thanks a lot for your reply.
I executed that you send me in your email, but give me same error.

Did you send and exemaple about you tell me?
Do you know any web have some examples about that?

Again thank you
Re: SQL LOADER [message #208237 is a reply to message #208201] Fri, 08 December 2006 14:43 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The '.' after a filename without an extension will work for Windows platforms, so apparently you aren't on Windows. Your only option may be to rename the files to include an extension.
Re: SQL LOADER [message #208247 is a reply to message #208237] Fri, 08 December 2006 16:19 Go to previous message
AnamCara
Messages: 3
Registered: December 2006
Location: Madrid, Spain
Junior Member
Hi,
Yes, you are right. I am working in UNIX environment. Thanks a lot
Previous Topic: SYS.UTL_FILE Error in Oracle 10g
Next Topic: Optimised solution for Data Migration
Goto Forum:
  


Current Time: Sat Dec 10 22:42:28 CST 2016

Total time taken to generate the page: 0.22717 seconds