Re: IMPDMP Log File Not Released

Do you have any idea which specific process is locking that file?

Microsoft SysInternals Process Explorer or Microsoft Resource Monitor could be used to identify that process That might be a major step into identifying what is different about the QA machine or that specific job.

/Hans

On 2017-02-10 9:19 AM, Dave wrote:
> Hello All,
>
> MSWindows 2008, Oracle SE 12.1.0.2
>
> To refresh our QA and DEV database we run a number of impdp/expdp jobs
> every Tuesday night. Each job is run twice, once against each
> databases. QA and DEV databases are essentially identical
>
> Out of the the 20 jobs I have a problem with one of them on our QA
> machine. The impdp completes properly but the Windows service refuses
> to release the log file after the import is complete. Shutting down
> the instance does not release the file, the Windows service has to be
> stopped. Then the file can be removed. Note, all other imports on this
> machine work fine.
>
> Any ideas why? The fact this does not happen on the DEV machine or the
> with the other imports is extremely confusing to me.
>
> TIA
> Dave
>

--
http://www.freelists.org/webpage/oracle-l