About ABIS
All CoursesbalkjeGeneral Introduction to HW & SW Soft skills TracksOperating systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad and iPhone iOSDatabases and middleware Relational databases & SQL DB2 for z/OS DB2 for LUW Oracle SQL Server MySQL & MariaDB IMS CICS IBM MQ WebSphere Big data and analyticsApplication development Methods and techniques TOGAF PRINCE2 Agile development and Scrum Programming languages Internet development Object Oriented systems Java Development tools SAS XML SOA & web servicesSystems management ITIL SecuritybalkjePractical informationRegistration 
Oracle database administration for DB2 DBAs


This course compares the most important characteristics of the Oracle database system with DB2. The most important Oracle specifics are discussed in detail. At the end of this course, the participant will have a thorough overview of the most significant differences between Oracle and DB2.

Main topics

  • The Oracle database system:
  • instance • database
  • Oracle physical object structure:
  • storage • tablespaces • segments, extents, blocks
  • Oracle logical object structure:
  • schema objects • generic schema observations • some object specifics (tables, indexes, views, partitions, ...)
  • Catalog:
  • catalog • performance tables
  • Security concepts:
  • logical vs physical security (integration with OS security mechanisms)
  • type privileges • roles
  • Undo management.
  • Basic utilities:
  • export/import • datapump • loader
  • backup/recovery
  • Locking in Oracle:
  • lock types • 'versioning' in Oracle vs explicit locking in DB2
  • Performance and tuning:
  • explain utility • trace
  • dynamic vs static SQL in Oracle

Intended for

Analysts, programmers and database administrators who are going to use Oracle. Everyone -with a DB2 background- who wants to gain an insight into the Oracle RDBMS.


General IT knowledge and familiarity with DB2 -at the level of application development- are required (see DB2 for z/OS fundamentals course).

Training method

Classroom instruction with exercises.

Course leader

Kris Van Thillo.


3 days.


No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Global score

4.3/5 (based on 102 evaluations)


Goede samenvatting/overzicht (, )
Veel bijgeleerd, zeer interessant (, )
Zeer duidelijke manier om de werking van Oracle uit te leggen (in combinatie met de verschillen met DB2) (, )
cursus voldoet compleet aan de verwachtingen ook qua documentation (, )
Prima, Prima Kennismaking met Oracle, duidelijk uitgelegd door Kris. (, )
Zeer goede presentatie. Steeds proberen aan te sluiten op onze DB2 achtergrond. (, )
Excellent! (, )
Aan te raden (, )
very good learned a lot! (, )
goede presentatie om DB2 te vergelijken met oracle, wat de bedoeling was! (, )

Refresh this page to see other comments.