Re: AFTER CREATE trigger (object actually being REPLACED)

Syltrem wrote:
> 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

The only way I can think of doing this would be to query all_objects, or a similar source, to see if the object already exists in the named schema.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org