RE:Challenge: tables under V$LOG

eric.giguere_at_m3isystems.com wrote in article <881096152.26491_at_dejanews.com>...
> 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,
>

Since V_$LOG is a fixed view you cannot put triggers on this object.

> 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..

I have simulated the same once by writing some Unix shell scripts. Write a shell to monitor the alert file and grep for the 'Thread 1 advanced to log sequence <next seq no>' and if it is success then ftp the corrsponinding file to the stand-by server etc. You can schedule this job in Cron or some other scheduler.

Thanks, Received on Wed Dec 03 1997 - 00:00:00 CST