Re: triggers on materialized views



Papa Piquillo schrieb:
Oracle 9.2.0.6 on hp-ux 11.11
Is supported by Oracle the use of triggers on materialized views?
I have seen that you can create them but i haven't seen documented
anywhere. Thanks.


Not a direct answer to your question, but, i'm using them since above 1 year to capture replicated deltas by fast refresh for further processing. Maybe not the most effective solution, but i haven't any problems till now.

Best regards

Maxim
.



Relevant Pages

  • Re: architecture issue
    ... and having little knowledge about Oracle I need your help. ... it's responsible for triggers management on oracle. ... notify my server running on a remote machine when fired. ... Open up a connection to the server ...
    (comp.databases.oracle.misc)
  • Re: Automatic versioning of records to maintain a history
    ... I'm in right now I'm restricted to the Oracle development tools. ... triggers, but if I can shave development time from this task I would ... 'Shaving development time' is one thing, ... I have no problem assisting you with this task, ...
    (comp.databases.oracle.server)
  • Re: After statement level trigger iring before after row level trigger
    ... This is caused by the Oracle database engine. ... For enabled triggers, Oracle automatically performs the following actions: ...    First,statementlevel triggers are fired, and then row level triggers are fired. ... That is different to the documentation I have: ...
    (comp.databases.oracle.server)
  • Re: Hi all
    ... Triggers can easily get unmanageable and are ... tcross rapttech dot com dot au ... getting some orders for my project which i have developed using SQL ... Server.But some clients need Oracle version. ...
    (comp.databases.oracle.server)
  • architecture issue
    ... and having little knowledge about Oracle I need your help. ... it's responsible for triggers management on oracle. ... notify my server running on a remote machine when fired. ... Open up a connection to the server ...
    (comp.databases.oracle.misc)