Home » RDBMS Server » Server Utilities » sql loader file name extensions
sql loader file name extensions [message #70101] Sun, 14 April 2002 23:12 Go to next message
Steve
Messages: 190
Registered: September 1999
Senior Member
I'm trying to load an sql loader data file that has no file extension. ( eg. file is called abcd )
sql loader seems to insist on assuming there is a .dat extension on the file. I've tried single quotes, double quotes and every other combination.
I don't want to rename or copy the data file as they are stored in production and very large.
I'm running on hp-ux.

eg.
LOAD DATA
INFILE 'abcd'
INTO TABLE table1
etc.

produces the error message:
SQL*Loader-500: Unable to open file (abcd.dat)
HP-UX Error: 2: No such file or directory

Report message to a moderator

Re: sql loader file name extensions [message #70107 is a reply to message #70101] Mon, 15 April 2002 08:45 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Create a symbolic link to the file.

ln -s abcd abcd.dat
sqlloader ...
unlink abcd.dat

Report message to a moderator

Re: what is a loader operating system? [message #70979 is a reply to message #70101] Wed, 21 August 2002 17:51 Go to previous message
geral yn
Messages: 1
Registered: August 2002
Junior Member
the responsibility of the operating system to load and execute files.the part of the operating system that performs this funtion

Report message to a moderator

Previous Topic: How do I convert date from Access to Oracle?
Next Topic: FREE OCP PAPERS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 05 19:47:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.