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

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.

Yes-not all Oracle 'errors' are truly errors. I've got a classic picture on my wall that I took of a screen when I was installing Oracle (7.2 IIRC). The box says 'Oracle Error'. The message is 'ORA-00000: normal, successful completion'. Go figure. Received on Fri May 11 2001 - 11:53:49 CDT