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: show errors

Re: show errors

From: <sybrandb_at_my-dejanews.com>
Date: Wed, 26 May 1999 12:33:24 GMT
Message-ID: <7igpml$ldn$1@nnrp1.deja.com>


This will not work, as the error tables track pl/sql compilation errors only. The only way to track user-errors is setup the audit mechanism and audit every unsuccessful statement and/or put the database in trace. Hth,

Sybrand Bakker, Oracle DBA

In article <374ba8e0.0_at_145.227.194.253>,   "Mark Gumbs" <mgumbs_at_nospam.hotmail.com> wrote:
> Look at user_errors
>
> M
>
> Doug Cowles wrote in message <374B1F8B.C216F885_at_bigfoot.com>...
> >What table does show errors query? Someone reported a rollback
problem
> >but wasn't particular about what it was. Snapshot too old, not
enough
> >etc.,
> >I don't know. I'd like to find out. Can I query the error table to
> >find out?
> >
> >- Dc.
> >
>
>

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply


--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 26 1999 - 07:33:24 CDT

Original text of this message

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