On Sep 28, 5:04 pm, Niall Litchfield <niall.litchfi..._at_dial.pipex.com>
wrote:
> zigzag..._at_yahoo.com wrote:
> >> 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.
>
> remote desktop is a technology that is not especially suited to long
> running operations - I'd use vnc or just plain at for that. I can do
> pretty much anything I like to my production servers remotely - but I
> don't trust remote desktop to deal well with iffy network comms, client
> desktops going into sleep mode and a number of other things. let the imp
> run actually on the server and poll the log file periodically.
> --
> Niall Litchfield
> Oracle DBAhttp://www.orawin.info/services
I suspect that is the cause of the problem. My import took ~ 12hours
to complete (database was 40GB in size), next time I run it using at
or thorugh Windows Scheduler.
Received on Fri Sep 28 2007 - 19:48:54 CDT
