Re: The first oracle 11.2.0 problem:

From: Palooka <nobody_at_nowhere.com>
Date: Thu, 03 Sep 2009 13:32:52 +0100
Message-ID: <UHOnm.55181$tD4.25290_at_newsfe07.ams2>

On 03/09/09 09:59, Mladen Gogala wrote:
> SQL> select distinct adr_home from v$diag_alert_ext
> 2 /
> select distinct adr_home from v$diag_alert_ext
> *
> ERROR at line 1:
> ORA-48216: Field Len Exceeds Max Field Length [5] [0] [20] [20]
>
> That means that the definition of adr_home is shorter than the actual
> data. Bummer. The table is practically useless because of that. Shame, I
> was sort of hoping that I will be able to browse through alert log
> messages by date and code. Oracle 11gR1 had a X$ table, inaccessible
> to the outside world and this was a nice perk. Unfortunately, it doesn't
> work.
>

Just a thought: What about looking at the SQL for the view and creating your own SQL or view on whatever is/are the X$ table(s)?

Palooka Received on Thu Sep 03 2009 - 07:32:52 CDT