2

Is it possible to create a trigger that fires when a view is created on a user schema?

I want to create a meta data table which will hold all the views and a listing containing what they are supposed to do. In this system (Oracle 9.2.0.8) there is only one user who has the create view privilege so that may make it easier.

The sequence of events should be something like view is created trigger fires and inserts the name of the view in the table of meta data table

I could write up some package to create views using dynamic sql but that seems a bit of overkill

4

You can use DDL triggers in Oracle.

I haven't actually done this myself, so here are some links:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.