I have a script that I run which performs some SQL to remove a user and then runs an import which creates the user and the objects that the user owns (Exported for a live DB).
When I run this script manually, it works fine but when the script is left to run though at it seems to hang leaving no relevant messages for me to use to debug the problem. We are running NT 4 with Oracle 8.0.4.
Here is the script:
sqlplus /nolog @e:\ora-script\azr2_ezl.sql
* Up until this point it all works, it hangs on the import *