Home » SQL & PL/SQL » SQL & PL/SQL » Logging DMLs (Small help required)
Logging DMLs [message #397800] Mon, 13 April 2009 23:55 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

Is there any table or view in oracle which capture the log details of all data modification? V$SQL holds the statement which I don't want.

We are writing the script which pulls data from different tables in different database to one single database. I have to write a script for incremental job which will pull data which has been modified after last run of the job.

Please reply ASAP.

Thank you

[Updated on: Tue, 14 April 2009 00:53] by Moderator

Report message to a moderator

Re: Small help required [message #397801 is a reply to message #397800] Mon, 13 April 2009 23:56 Go to previous messageGo to next message
BlackSwan
Messages: 25133
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.


Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Re: Small help required [message #397806 is a reply to message #397800] Tue, 14 April 2009 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64270
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for Log Miner in the documentation.

Regards
Michel
Re: Small help required [message #397809 is a reply to message #397806] Tue, 14 April 2009 00:48 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michel,

I didn't get this .Can you explain me clearly please.
Re: Small help required [message #397815 is a reply to message #397809] Tue, 14 April 2009 01:02 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You have been pointed to the documentation at least 400 times now.
How can you NOT understand Michel's comment?!
Previous Topic: Time spent for the statements inside a procedure
Next Topic: Exceptions
Goto Forum:
  


Current Time: Tue Jan 17 22:24:12 CST 2017

Total time taken to generate the page: 0.11846 seconds