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 *
You are trying to import full database (FULL=Y) where as the export dump file was taken at user level.
Change the imp parameter.
09-04-2001, 05:24 PM
Not true! FULL=Y as an import parameter only means that you want the whole contents of the dump file to be imported. So it doesn't matter if export was done at FULL, USER or TABLE level. Parameter FULL has totaly different meaning in imp as it has in exp.
To the original question:
Under which user is the Scheduler service runing on NT? As a SYSTEM acount or as a named user? Are the H: and E: disks local disks or are they mounted remote disks?
09-10-2001, 10:51 AM
Thanks for getting back to me.
H: is a mounted drive, it's the E drive from the live server which is where I store my dumps, I guess it would also help for me to show you how the file is dumped: