OraFAQ Forum: SQL & PL/SQL » Transaction Logging

Home » SQL & PL/SQL » SQL & PL/SQL » Transaction Logging (Oracle 10g)

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

Transaction Logging [message #338637]

Tue, 05 August 2008 09:09

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

Report message to a moderator

Re: Transaction Logging [message #338643 is a reply to message #338637]

Tue, 05 August 2008 09:28

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

pcd_lou
Messages: 63
Registered: October 2007
Location: Florida

Member

Ramanajv1968,

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

Thanks,
Lou

Report message to a moderator

Re: Transaction Logging [message #338652 is a reply to message #338637]

Tue, 05 August 2008 10:15

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

Senior Member
Account Moderator

Quote:

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

http://tahiti.oracle.com

Regards
Michel

Report message to a moderator

Previous Topic:	Need help in sequence.
Next Topic:	Bulk Updation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 02:53:39 CST 2025