Home » SQL & PL/SQL » SQL & PL/SQL » Set Alert on a Table (Oracle 10G)
Set Alert on a Table [message #433481] Wed, 02 December 2009 09:11 Go to next message
bholeuday
Messages: 28
Registered: April 2009
Location: Talavali
Junior Member

Hi,

I want to know how to set an ALERT on a Table to accomodate some report job.

Thanks in advance..

Thanks & Regards
Re: Set Alert on a Table [message #433483 is a reply to message #433481] Wed, 02 December 2009 09:14 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
What do you mean by alert?
Re: Set Alert on a Table [message #433484 is a reply to message #433483] Wed, 02 December 2009 09:16 Go to previous messageGo to next message
bholeuday
Messages: 28
Registered: April 2009
Location: Talavali
Junior Member

I need to set alert monitoring on a Table..but do not know much about the same.
Re: Set Alert on a Table [message #433486 is a reply to message #433484] Wed, 02 December 2009 09:20 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I need to set alert monitoring on a Table..but do not know much about the same.

We don't know exactly what you mean by "alert monitoring".
Re: Set Alert on a Table [message #433487 is a reply to message #433486] Wed, 02 December 2009 09:22 Go to previous messageGo to next message
bholeuday
Messages: 28
Registered: April 2009
Location: Talavali
Junior Member

I want to create EVENT ALERTS on Table which will triggered when an event or change is made to a table in the database.
Re: Set Alert on a Table [message #433488 is a reply to message #433487] Wed, 02 December 2009 09:29 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
bholeuday wrote on Wed, 02 December 2009 07:22
I want to create EVENT ALERTS on Table which will triggered when an event or change is made to a table in the database.


I suspect you will need to write some sort of trigger.
Your problem statement is way too vague to provide any specific advice.

We don't know what you specifically classify as an event or exactly what action you want taken when it occurs.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Set Alert on a Table [message #433490 is a reply to message #433481] Wed, 02 December 2009 09:32 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Do you mean auditing? or the Oracle Alerts product???
Previous Topic: Package Not Getting Compiled (merged 3)
Next Topic: Inequality slowing down UPDATE
Goto Forum:
  


Current Time: Fri Dec 09 13:49:18 CST 2016

Total time taken to generate the page: 0.07919 seconds