Shell Programming and Scripting

I have a script which has the following statement,

/opt/oracle/product/9i/bin/sqlplus << EOC >> $LOG_FILE 2>&1
username/password ---- Enters the SQL prompt
@/export/home/oracle/shells/grant_userview.sql ---Runs the SQL script
@/export/home/oracle/shells/grant_proc_userview.sql ---Runs the SQL script
@/export/home/oracle/shells/createindex.sql ---Runs the SQL script
exit --- Exits the SQL prompt
EOC

imp system/password file=/oradata/temp/user.dmp fromuser=user 1 touser=user2 indexes=y log=user.log -- Runs on $ prompt.

The statement in red above doesnt run. When run out of the script manually it succeeds, I am trying to figure if i have to move this "exit" below the last line, Please advice

Does it produce an error?

(and what is the 1 between the fromuser and touser part)?

Code:

fromuser=user 1 touser=user2

Just as a thought: Is that imp command you show exactly the command you run from the script, or is the username/password, for example, in a variable? If so, did you export the varaible?

The exit isn't neccessary either in the SQL*Plus or the script. You should replace it with a / in the SQL.

What happens if you add the full pathname to imp?

Hi Scottn/fpmurhpy,

No there is no export of username/password required in the script because it contains the original username and password.

This script was running and since couple of days it terminates and doesnt run that imp command.

Thanks.

What does user.log say?

Remove the exit anyway, as it's not required.

file=/oradata/temp/user.dmp
is this file available in that location..

If you enable tracing, you should be able to see what happens.