Home » SQL & PL/SQL » SQL & PL/SQL » Trigger Problem (Oracle9i,9.2.0.6.0,Windows XP)
Trigger Problem [message #312074] Mon, 07 April 2008 22:31 Go to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear All,

We can have row level triggers on individual tables.Now i have one requirement in which i have to track changes in 40 tables.

Can we specify one row level trigger that will record data in a master table for this group of 40 tables.

Master Table Will record Following value:
1) Table Name
2) Operation (insert,Delete)
3) Entire Row Which is inserted or deleted


Regards,
Rajat Ratewal
Re: Trigger Problem [message #312124 is a reply to message #312074] Tue, 08 April 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you must have a trigger for each table.
But depending on what you want to track, audit may be a better way.

Regards
Michel
Re: Trigger Problem [message #312568 is a reply to message #312124] Wed, 09 April 2008 05:18 Go to previous messageGo to next message
suneelvarma_27
Messages: 28
Registered: April 2008
Junior Member
no u can't do like this
Re: Trigger Problem [message #312570 is a reply to message #312568] Wed, 09 April 2008 05:33 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
suneelvarma_27 wrote on Wed, 09 April 2008 11:18
no u can't do like this

Why repeat the same answer that was given over a day ago?
Previous Topic: Moving table from one tablespace to other.
Next Topic: Index creation!! issue in production (merged)
Goto Forum:
  


Current Time: Mon Dec 05 19:25:44 CST 2016

Total time taken to generate the page: 0.17047 seconds