Category: Database

With the launch of DB 12c in 2013, Oracle introduced a new architectural concept, called “multitenant databases”, where you have one super database (=container; CDB) and one or more sub databases (= pluggable DBs; PDB). Before running the installer on an Oracle Linux 6 environment, a library can be installed through yum to meet all […]

In this post I will put 5 other new 12c features in the spotlight (in addition to the features of a previous post), that really makes the 12c an improvement against the previous versions of the Oracle database. To get this result I listed up all the major new features and wanted to know my […]

Last weeks I ran into some issues with APEX, so let’s take some time to write something about them. The most recent is about heterogeneous services (also referenced as HS). Here is the case: We have an Oracle DB instance with some APEX applications and in one of those applications I need data from a […]

There’s a new Oracle source available:  All Things Oracle. The aim of All Things Oracle is to provide a gateway to the wealth of information and material available for Oracle developers and DBAs. The site brings articles and other resources of Oracle experts. Just to name a few: Alex Nuijten -Database Development – Oracle Ace […]

Today I explained the “statement restart” problem to a colleague. Every database developer has to know about this one… Short: Any statement can be restarted! This means that when you do one update statement, oracle CAN restart the statement. Every code in a trigger can be executed multiple times, so watch out with package variables […]

Result cache… a very cool feature in the 11g database. If you don’t know it, this is a must read: Pl/SQL function result cache in 11g But also watch out with it in Forms 11g. It seems there’s a bug. When compiling a program unit that calls a function with result cache in forms, you’ll […]

  When trying to refresh a materialized view based on a query that uses a mssql table (using the SqlServer Gateway), I run into the following error: ORA-12008: error in materialized view refresh pathORA-01400: cannot insert NULL into (%s)ORA-02063: preceding line from MSSQLDB1ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2537ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2743ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2712 […]