AFTER CREATE trigger (object actually being REPLACED)

Hi

I have an AFTER CREATE trigger.
I can verify what kind of object has been created by using the
ora_dict_obj_type event attribute function, but is there such a function
that would tell me if the object is being added *or* replaced ?

The object here is a VIEW, and a CREATE OR REPLACE does not always create
the view... in such case I don't want to do anything but the trigger gets
fired anyway.

Or do I have to query DBA_OBJECTS to check CREATED and LAST_DDL_TIME to make
an educated guess ?

Or any better way that you know of...

Thanks

--
Syltrem
Oracle 10.2 on OpenVMS
http://pages.infinit.net/syltrem (OpenVMS information and help, en français)


.

Relevant Pages

  • [NEWS] Multiple Vulnerabilities in Oracle Database (Trigger, Extproc, Wrapped Procedures, PL/SQL Inj
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the Oracle database server. ... Oracle Trigger Abuse ... written in PL/SQL and execute with the privileges of the definer/owner. ...
    (Securiteam)
  • RE: Access Append Query to update Sequence Generator in Oracle
    ... Jerry Whittle, Microsoft Access MVP ... to be a Trigger for TASSIGNINTERVAL ... Also committing should not make any difference to the sequence or trigger. ... was that the Sequence Generator in Oracle remained at the last number PRIOR ...
    (microsoft.public.access.queries)
  • Re: Help for an Oracle Newbie
    ... application I wrote using SQL Server ported over to Oracle. ... Obviously there are several built in data types in SQL Server that do ... Of course I had to use a different name for the trigger under each ... In SQL Server I always create a CreatedDate column ...
    (comp.databases.oracle.server)
  • Re: Help for an Oracle Newbie
    ... application I wrote using SQL Server ported over to Oracle. ... Obviously there are several built in data types in SQL Server that do ... Of course I had to use a different name for the trigger under each ...
    (comp.databases.oracle.server)
  • Re: Before Insert Trigger
    ... I was running this on Oracle 9.2.0.5 on HP UNIX 11i. ... I have set up a trigger ... >> including unique constraint violation in the trigger. ... > for performance reasons as well as technical ...
    (comp.databases.oracle.server)