Home » SQL & PL/SQL » SQL & PL/SQL » database triggers
database triggers [message #297732] Sun, 03 February 2008 02:32 Go to next message
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
Re: database triggers [message #297735 is a reply to message #297732] Sun, 03 February 2008 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: database triggers [message #297753 is a reply to message #297735] Sun, 03 February 2008 06:28 Go to previous messageGo to next message
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
Re: database triggers [message #297763 is a reply to message #297753] Sun, 03 February 2008 09:31 Go to previous message
Alien
Messages: 245
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



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


Current Time: Wed Dec 07 12:36:52 CST 2016

Total time taken to generate the page: 0.10257 seconds