Re: Can not create table just hangs

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 31 Jan 2001 19:15:40 -0000
Message-ID: <980968373.14526.0.nnrp-07.9e984b29@news.demon.co.uk>

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 - 13:15:40 CST