Re: AFTER CREATE trigger (object actually being REPLACED)
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Thu, 29 Nov 2007 12:06:37 -0800
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@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- Follow-Ups:
- References:
- AFTER CREATE trigger (object actually being REPLACED)
- From: Syltrem
- AFTER CREATE trigger (object actually being REPLACED)
- Prev by Date: Re: webservice
- Next by Date: Re: Rebuild of indexes and 'Sweeper' referred in Ask tom site
- Previous by thread: AFTER CREATE trigger (object actually being REPLACED)
- Next by thread: Re: AFTER CREATE trigger (object actually being REPLACED)
- Index(es):
Relevant Pages
|
