OraFAQ Forum: SQL & PL/SQL » database triggers

Home » SQL & PL/SQL » SQL & PL/SQL » database triggers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database triggers [message #297732]

Sun, 03 February 2008 02:32

akramrabaya
Messages: 41
Registered: November 2007

Member

it happen sometimes : suppose i have a database trigger
on a table name name "issue"

the trigger name is "issue_ins" this trigger run before update on table issue ......

some times this trigger stop working and when i checked i find that another trigger issued on the same table and it is alsoo run before update and the trigger has a name "temp.issue_ins"

so becose we have two triggers on the same level ( before update ) non of them will work

my questions?
1. how that trigger "temp.issue_ins" issued automatically ???
2. even when i delete it it comes back agian after sometimes maybe weeks or maybe days

** something i noted alsoo may be it has a relation **
the current user of this table supose it is "akram"
there is another user i created alsoo with the name of "temp"
and i do sometimes emport the data from user "akram" to user "temp" but this problem still not happen to any table except that table named with "issue"
************************************************************

best regards and thanks in advance
akram

Report message to a moderator

Re: database triggers [message #297735 is a reply to message #297732]

Sun, 03 February 2008 02:53

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

it happen sometimes : suppose i have a database trigger on a table name name "issue"

So it is not a database trigger but a table trigger.

Quote:

1. how that trigger "temp.issue_ins" issued automatically ???

What do you mean "issued"?
Someone create it, Oracle does not generate triggers named like that.

Quote:

2. even when i delete it it comes back agian after sometimes maybe weeks or maybe days

See 1.

Audit "create trigger" statement or create a DATABASE trigger on DDL to know who is creating your TABLE trigger.

Regards
Michel

Report message to a moderator

Re: database triggers [message #297753 is a reply to message #297735]

Sun, 03 February 2008 06:28

akramrabaya
Messages: 41
Registered: November 2007

Member

1. sorry yes it is a table trigger

2. i mean by issued automatically is it is created automatically
when i go to the table and check what is the triggers on that table .. i find two triggers one of them i create .. but the other one i don't how it comes the table.....!!!!!

3. i create this trigger on the table my self !!!!!

i think the problem on the new user "temp"

cuz once i drop this user and create it agian and import all the data from the user "akram" this problem happen !!!!

akram

Report message to a moderator

Re: database triggers [message #297763 is a reply to message #297753]

Sun, 03 February 2008 09:31

Alien
Messages: 292
Registered: June 1999

Senior Member

Quote:

so becose we have two triggers on the same level ( before update ) non of them will work

Actually both will work. But I think you are saying that they do undo eachothers work?

Quote:

and i do sometimes emport the data from user "akram" to user "temp"

So you import the trigger as user TEMP. Stop doing that. Or fully drop the table (including the trigger) before you import it again.

Regards,

Arian

Report message to a moderator

Previous Topic:	Query to get the last 100 rows in a table
Next Topic:	Displaying output (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 14:27:56 CST 2025