Home » SQL & PL/SQL » SQL & PL/SQL » Transaction Logging (Oracle 10g)
Transaction Logging [message #338637] Tue, 05 August 2008 09:09 Go to next message
pcd_lou
Messages: 63
Registered: October 2007
Location: Florida
Member
Hey Guru's

I was looking for a way to log all the transactions (changes to a table) for a daily/weekly/monthly report(s).

I can log and off load them to Flat Sequential Files if need be.

I searched this database and found some references to:
- flashback query
- transaction flashback query
- log miner

Is there someplace I can find some information about these commands or procedures?

Thanks,
Lou
Re: Transaction Logging [message #338643 is a reply to message #338637] Tue, 05 August 2008 09:28 Go to previous messageGo to next message
ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD
Senior Member
Quote:
I was looking for a way to log all the transactions (changes to a table) for a daily/weekly/monthly report(s).


How about writing a database level trigger ?

[Updated on: Tue, 05 August 2008 10:14] by Moderator

Report message to a moderator

Re: Transaction Logging [message #338650 is a reply to message #338643] Tue, 05 August 2008 10:11 Go to previous messageGo to next message
pcd_lou
Messages: 63
Registered: October 2007
Location: Florida
Member
Ramanajv1968,

Ok..... How does that work? How do I do that?

Thanks,
Lou
Re: Transaction Logging [message #338652 is a reply to message #338637] Tue, 05 August 2008 10:15 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there someplace I can find some information about these commands or procedures?

http://tahiti.oracle.com

Regards
Michel
Previous Topic: Need help in sequence.
Next Topic: Bulk Updation
Goto Forum:
  


Current Time: Sat Dec 03 03:59:09 CST 2016

Total time taken to generate the page: 0.12123 seconds