On Sep 26, 7:21 pm, zigzag..._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.
Sorry I forgot to note that also possibly this error may have been
found and fixed by oracle since you are running 9.2.0.6 if it is
oracle software related and not something specific to the database
specifically you are running against.
Received on Sat Sep 29 2007 - 03:29:11 CDT
