Re: Challenge: tables under V$LOG

Hi,
Try
SELECT * FROM V$FIXED_VIEW_DEFINITION WHERE VIEW_NAME='V$LOG';             Peter.

eric.giguere_at_m3isystems.com wrote:

> Hi,
>
> How can I find which table(s) are reference by the view V_$LOG?
>
> When I look in the catalog, I can see that V$LOG is a synonym for the view
> V_$LOG. When I look to the text of the view V_$LOG, I see a reference to
> the synonym V$LOG?!
>
> What is the real table under that view?
>
> I really need to know the table under that view because I want to
> implement a trigger that will notify (I don't want to poll) me on log
> switch. This way I will be able to ftp the corresponding archive log on
> my Stand-by server...
>
> Thanks,
>
> ****************************************************************************
> CATALOG
>
> select * from dba_synonyms where synonym_name='V$LOG';
>
> OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME
> ------- ------------ ----------- ----------
> PUBLIC V$LOG SYS V_$LOG
>
> select * from dba_views where view_name='V_$LOG'
>
> OWNER VIEW_NAME TEXT_LENGTH
> TEXT
> -------------------------------------------------------------------------
> SYS V_$LOG 115
> select
> GROUP#","THREAD#","SEQUENCE#","BYTES","MEMBERS","ARCHIVED","STATUS","FIR
> ST_CHANGE#","FIRST_TIME" from v$log
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Dec 03 1997 - 00:00:00 CST