when does expdp/inpdp starting writing logfile?

[raygg]

I started a long-running expdp using a parfile and specifying a dumpfile and a logfile etc. Unfortunately the pc went into an automatic reboot about 15 minutes later killing the dos job and everything else. However I saw the dos messages prior to the shutdown listed the name of the first table of many tables in the tablespace selected for output. I know the only dataobjects that will be selected for output will be tables. I looked for a partial logfile but none was in the designated directory nor was there a partial dmp file. I do not have a lot of experience using datapump (but I used exp/imp a lot) and never had a shutdown dill a datapump or exp/imp job before. I presumed that at least a partial logile would get written to output immediately to mirror all the lines sent to the dos windows. Apparantly not. So when does it happen?

 

[SantaMufasa]

raygg,

I believe that Oracle actually opened the logfile and began writing to it, but (unlike Unix/Linux), you don't start seeing evidence of the file and its contents until there is enough output to the logfile to fill the first o/s block, thus needing to write to a second block. At best, the PC shows you a logfile with "0" bytes (despite writing some data) because Oracle has not closed the file.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[raygg]

That's what my intuition told me I would find but there was not even a log file name with 0KB size showing in the folder. I am running on XP fyi.