Challenge: tables under V$LOG

From: <eric.giguere_at_m3isystems.com>
Date: 1997/12/02
Message-ID: <881096152.26491@dejanews.com>#1/1

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 Tue Dec 02 1997 - 00:00:00 CST