Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import problems on Windows Server
On Sep 27, 5:12 pm, Niall Litchfield <niall.litchfi..._at_dial.pipex.com>
wrote:
> 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.
>
> How are you logged onto the server? At the physical console?
>
> --
> Niall Litchfield
> Oracle DBAhttp://www.orawin.info/services- Hide quoted text -
>
> - Show quoted text -
I logged on the server using Remote Desktop.In my company so many
production databases have been setup on WIndows Server because of its
low cost. I have not heard major problems. I am still perplexed why
import log stopped
while import ran successfully.
Received on Thu Sep 27 2007 - 18:54:00 CDT