HomeНаука и техникаRelated VideosMore From: Connor McDonald

How to detect data changes and notify applications of those changes

19 ratings | 672 views
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Html code for embedding videos on your blog
Text Comments (4)
Justin Michael (3 months ago)
Wow, this is awesome
Emanuel Oliveira (6 months ago)
once again great overview video from you ;) We use triggers for both normal journaling and to send messages to downstream systems (gigaspaces). I enjoyed the Flashback idea, despite control to access Flashback data is a point in time right or any way to get physical sequence ?
Emanuel Oliveira (6 months ago)
Connor McDonald oh you right thats great and seems our lovely oracle :D offers full detail including scn's, xids and even operation type (I for insert, D delete and U update) as I just found learned in: http://www.oracle-developer.net/display.php?id=320 I haven't used in production Flashback feature, shared it with other colleagues in some desperately times in dev/test environments lol, im going to deep learn more about Flashback it seems. Is there some way to control what tables we would like flashback or not? Or by default all tables are Flashed?
Connor McDonald (6 months ago)
you should be able to use the "versions between" syntax to get a sequenced list of changes to the table

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.