Home » RDBMS Server » Performance Tuning » need help! how to intercept sql command of update (Oracle 10g xe, Windows xp)
need help! how to intercept sql command of update [message #305876] Wed, 12 March 2008 05:17 Go to next message
jarbouni
Messages: 19
Registered: March 2008
Junior Member
Hello all,
I work in a project of Oracle databases synchrinization, and i need to intercept any sql commond (requête) that responsable of changes in my database, i need to save all the commond syntaxe in a txt file for future interpretation.
some people advice me to use logMine tool, and other advice me to use trace file and Pkprof tool,
please i need your help, how can i start.
Thanks in advance.
Re: need help! how to intercept sql command of update [message #305901 is a reply to message #305876] Wed, 12 March 2008 05:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to start to explain what is the final purpose.
The way to do it depends on the result you want.
Among the tools for synchronization, you also have triggers, materialized views, data guard, streams, datapump (exp/imp)...

Regards
Michel
Re: need help! how to intercept sql command of update [message #305917 is a reply to message #305901] Wed, 12 March 2008 06:02 Go to previous messageGo to next message
jarbouni
Messages: 19
Registered: March 2008
Junior Member
thanks for your attention,
My project consist to do a synchroniztion beteween 2 DB Oracle, in a distributed environnement, the idea is to save any change in the both DB in a txt file and use this file to applicate there changes in the other DB, so i need to intercept any change in my DB (sql queries of update), i work with Oracle xe, so i don't have many tools like streams or other,
Thanks in advance for any help,and if there is better idea, i will take it.
Re: need help! how to intercept sql command of update [message #305924 is a reply to message #305917] Wed, 12 March 2008 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
My project consist to do a synchroniztion beteween 2 DB Oracle,

The whole database?

Regards
Michel
Re: need help! how to intercept sql command of update [message #305949 is a reply to message #305876] Wed, 12 March 2008 06:49 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The topic continues in french in the French forum.
I will post a synthesis here at the end.

Regards
Michel
Previous Topic: Query takes too much time
Next Topic: package not completing
Goto Forum:
  


Current Time: Wed Dec 07 02:39:50 CST 2016

Total time taken to generate the page: 0.10584 seconds