Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: Import problems on Windows Server

From: <zigzagdna_at_yahoo.com>
Date: Thu, 27 Sep 2007 16:54:00 -0700
Message-ID: <1190937240.283884.45860@o80g2000hse.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US