Re: trigger and V$ tables

From: David J. Roth <droth_at_sii.com>
Date: 1996/12/05
Message-ID: <01bbe2f8$1f81fd00$8b0ebe9b@droth.sii.com>#1/1

The V stands for View and triggers are not permitted on views (until Oracle8).

The views and based on system tables. In early releases I think you could create triggers on the tables owned by sys if you had the privs. But this was a no-no.
I think the newer releases block triggers on sys tables.

-- 
David J Roth
(My own opinions)

Maja Matulovic <maja_at_laetitia.inria.fr> wrote in article
<58716d$6mv_at_news-rocq.inria.fr>...


> 

> -- 

> Hello, 

> 

> I would like to know if anyone tried to declare a trigger on

 V$<table_name>


> 

> Thanks

> 

> Maja Matulovic

>

Received on Thu Dec 05 1996 - 00:00:00 CST