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
(and what is the 1 between the fromuser and touser part)?
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.