I have following batch script:
copy \\remotehost.ip\c$\dumps\TEST_%date%.dmp C:\dumps\TEST_%date%.dmp sqlplus sys/password as SYSDBA @C:\dumps\recreate_test.sql > C:\dumps\recreate_test.log timeout /t 10 impdp system/password@sid schemas=TEST,TEST_VIEW directory=dumps_dir dumpfile=TEST_%date%.dmp logfile=impdpTEST_%date%.log
It copy sql dmp file from remote host in the same network. Then run script that recreate users in database:
shutdown immediate; startup restrict; drop user TEST cascade; drop user TEST_VIEW cascade; create user TEST identified by password; create user TEST_VIEW identified by password; grant all privileges to TEST; grant all privileges to TEST_VIEW; EXEC DBMS_UTILITY.compile_schema(schema => 'TEST'); EXEC DBMS_UTILITY.compile_schema(schema => 'TEST_VIEW'); shutdown immediate; startup; exit;
Then run import script. All this SQL have got log files and it seems everything runs good. I have got some errors during import, but they just told me that user already exists (
ORA-31684) and import everything in this existing user and also got
ORA-39082 error, which was meant to be fixed with
DBMS_UTILITY (yes, I see my error here, but it's not the point) later.
I run it with highest privileges. System administrator allowed me to check option
Run whether user is logged on or not and option
Do not store password. It has 0x5 code even if I run task manually selecting
Run from dropdown menu in Task Scheduler.
Why my task ends with 0x5 error code if everything runs good? I've seen logs, they're good.