Hey DBMS_COMPARISON! - Are my Tables in sync?
Track
Database & Infrastructure
Date and time
Friday, 20. October 2023., 09:55
Room
Hall C
Duration
45'
Nowadays, companies have a lot of databases to store their data. Besides the application-specific data, master data is required (e.g. customer or employee information) to run the application. If the data is replicated between many databases, it is essential that the data and its tables are fully synchronized - especially when a non-Oracle replication technique is used (e.g. a third-party application).If you want to check if the data is in sync, you can use the PL/SQL package DBMS_COMPARISON. With the capabilities of this package, you can compare two tables or materialized views between different schemas or different databases using a database link connection.The presentation will explain the features of DBMS_COMPARISON in detail. After an introduction to the package, a closer look at the internals will be executed. Some of the features are part of a live demo.At the end of the presentation alternatives to this package will be introduced.
Lecture details
About speaker
Christian Gohmann, author
Christian Gohmann is currently working as Data Engineering Associate Manager and Instructor at Trivadis - Part of Accenture in Dusseldorf, Germany. His main focus lies in helping customers in the areas of architecture planning, implementation, and migration - with a specialization in high availability solutions, like Data Guard, Oracle RAC.Since 2006, Christian Gohmann is working with Oracle and the Oracle Database and was part of a huge amount of different projects for customers in German-speaking areas. Besides his consultancy activities, he is the main developer and the responsible person for db*BACKUP - a product distributed by Trivadis, which is responsible for the intelligent backup and recovery of an Oracle database.In his spare time, he shares his knowledge on his blog https://www.christian-gohmann.de and spends as much time as possible with his two dogs Susi and Taran, and for his hobbies climbing/bouldering, hiking, and watching movies.
T-Shirt Sponsor
Venue Sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.