Re: Archive Log Warning..... How do I fix it? - Oracle archive error.jpg (0/1)

Hi Mark,

Thanks for responding.

The warning appears in a DOS box on the NT desktop when I issue the ALTER command. When the warning message appears, access to the table i'm trying to access can no longer be accessed (IE. if I issue an SQL command against the table SQL Plus locks up and doesn't return).

I can't find an ALERT.LOG, but ARC???????.LOG are being created just fine.

The table I am altering is in use, but since I am only adding a column I didn't think I needed to shut anything down. The table doesn't have Stored procs or packages.

If I do have to shutdown oracle to fix this problem, do I issue the following in SVRMGR30:
SHUTDOWN
<perform my TABLE Alterations with SQL Plus/Worksheet> STARTUP Will that be the easiest way to do it?

On 10 May 2001 12:46:31 GMT, xmark.powell_at_eds.com.x wrote:

>In article <05ljfts43nuspotp9nppgl6tkdgafahkhm_at_4ax.com>, Alex Skolnick
><ak_at_e-brag.com> writes:
>>Hi All,
>>
>>I am encountering a wierd warning message when altering a table with
>>the Shema manager and SQL Plus.
>>
>>When adding new columns using Shema manager or SQL Plus, the
>>applications freeze up and my oracle Server displays the warning
>>message. It will be difficult to explain so I have enclosed a picture
>>of the warning.
>>
>>SVRMGR30.exe reports the following:
>>Database log mode Archive Mode
>>Automatic archival Enabled
>>
>>Operating environment:
>>Winnt SP5
>>Oracle 8
>>Over 4 gigs of drive space available.
>>
>>Any and all help would be greatly appreciated.
>
>Alex, where is the warning. All I see is standard information messages. Wher
>are these messages being displayed, on your screen or in the alert.log?
>
>When you are having this problem are there any error messages in the alert.log
>or are any trace files being generated?
>
>Are the tables you are altering in use, are there packaged or stored
>procedures defined on them?
>
>I think we need more information to determine the problem.
>
>-- Mark D. Powell --
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
>made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Mon May 14 2001 - 10:58:16 CDT