| need help! how to intercept sql command of update [message #305876] |
Wed, 12 March 2008 05:17  |
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 #305917 is a reply to message #305901] |
Wed, 12 March 2008 06:02  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
