Fastload Script is Erroring out with the Highest error code='8' while Running a shell script

Tools
Enthusiast

Fastload Script is Erroring out with the Highest error code='8' while Running a shell script

Hi All,
I tried to run a fastload shell script which populates the table with the data available in a text file

I have invoked the text file by using FILE=INIT.txt and the text file is avaliable in the same file as that of the shell script and I have provided the highest Permission (chmod 777) to both the files.

But I am getting a message like "Cannot open file: 'file' in fastload" with the Highest return code='8'.

Similarly how to drop an already existing error table in TPUMP.

Thanks in Advancwe for any kind of Help Rendered in these regards.

3 REPLIES
Enthusiast

Re: Fastload Script is Erroring out with the Highest error code='8' while Running a shell script

From which directory are you calling the fastload? See, if the directory where the files are, can be accessed from the directory from where you are invoking the fastload. Though the files have a universal access, if the owners are different, then the script may not be able to access those files. The user, who is invoking the fastload should have access to those files. So, I'd suggest you make appropriate Chown commands to see if the script runs successfully.
Enthusiast

Re: Fastload Script is Erroring out with the Highest error code='8' while Running a shell script

Define the file path exclusively. That should solve the fastload issue.

To drop the error table just use drop table statement.
Enthusiast

Re: Fastload Script is Erroring out with the Highest error code='8' while Running a shell script

Hi All,

Sorry for the Delayed Reply.
Thanks for your Reply.

I have found out the Problem and is now working fine.

Atually the problem was with the Format of the Input file from which the data is being loaded into the the tables.

Please do keep in touch.