Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Import problems on Windows Server

Re: Import problems on Windows Server

From: hpuxrac <>
Date: Sat, 29 Sep 2007 01:26:53 -0700
Message-ID: <>

On Sep 26, 7:21 pm, wrote:
> I am using Oracle 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.

If there is not an entry in the import log aka "import terminated with no errors" or "import terminated with errors" ... and the imp process is still running ... then you need to figure out what is going on exactly.

This is not ( necessarily ) a windows versus unix problem it is just a basic oracle problem.

What was/is the import process waiting on exactly? It is the usual session based diagnostic approach that can be followed here.

Maybe you are in archivelog mode and you are out of space?

Not surprised exactly that Captain Morgan throws in the usual not relevant bashing approach. Received on Sat Sep 29 2007 - 03:26:53 CDT

Original text of this message