Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Thu Nov 29 2007 - 12:34:02 CST
![]() |
![]() |