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: Can not create table just hangs

Re: Can not create table just hangs

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 1 Feb 2001 06:29:50 -0000
Message-ID: <981008791.3862.0.nnrp-07.9e984b29@news.demon.co.uk>

init.ora (or v$parameter) value

    log_archive_start = true/false

Then watch out for your log archive destination(s) getting full.

--
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



Mo wrote in message <3A78A569.8671A275_at_mailbox.bellatlantic.net>...

>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 Thu Feb 01 2001 - 00:29:50 CST

Original text of this message

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