zigzagdna_at_yahoo.com wrote:
> I am using Oracle 9.2.0.6 on Windows 2000. I ran an import which takes
> many hours. 1st time I ran import, it "finished". When I looked at
> import log file, it did not complete import of all the tables.
> Verified that whatever tables specified in import are the only tables
> imported in database.
>
> Deleted all the objects in schema and redid import. This time it went
> beyond last time, import log file showed more tables. But then import
> stopped writing to log file, however import was still going on. I
> looked in database it has all the tables, views etc, so import
> seems successful. Why import log was not updated? Import log time
> stamp shows that lwriting to log was stopped 10 hours ago. Imp
> process was still running,
>
> I do not see any error messages written to alert log file or in
> Windows event logs. What is going on? I have done import on Windows
> server on several other databases, did not encounter such problems in
> the past.
I've never seen this behavior but then I never run Oracle on Windows
for production. From that you may be able to draw your own conclusion. <g>
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Sep 27 2007 - 10:39:52 CDT
