Re: Can not create table just hangs

Hi Jonathan

Yes, I have archive logging on, but not sure about automatic archival off. (I'll check it tomorow)

How to check for it anyway?
and why this automatic archival off cause the hanging on creating tables and I even got the system hang in the middle of Import and nothing work until the database was shutdown and restarted.

Thanks
Mo

> Is it possible you have archive logging on,
> but automatic archival off ?
>
> Any hints from messages in your alert log ?
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
>
> Publishers: Addison-Wesley
> More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
> MAbbouchi_at_IITRI.ORG wrote in message ...
> >Installed Oracle 8.1.7 a month ago and it still unstable.
> >
> >Today, when I try to create a table from DBA studio or SQL PLUS it just
> >hang, until closing it.
> >
> >I went to the server to shut down the instance from the DBA studio and it
> >also hang with nothing else
> >can be done except killing it, then I started the instance back and I was
> >able to shutdown normally
> >then start again with no problems.
> >
> >what could be causing this problem??
> >
> >is there a patch for 8.1.7 release yet???
> >
> >Thanks
> >Mo
> >
> >--
> >Posted from nat05.IITRI.ORG [205.167.170.5]
> >via Mailgate.ORG Server - http://www.Mailgate.ORG
  Received on Wed Jan 31 2001 - 17:51:27 CST