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

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