Migrating Oracle Enterprise Edition database To Standard Edition using Transportable Tablespaces

Johan Buijser

Introduction Oracle database Standard Edition (SE)  has the main features of a RDBMS database and cost significantly less than Oracle Enterprise Edition (EE). Migrating a database from Oracle Enterprise Edition  to Standard Edition can be a consideration ifthe Enterprise Edition options or features are not used (or not required) in […]

Brief: What is Oracle Wallet?

Lucas Jellema

An Oracle Wallet is an encrypted file that contains database credentials – username and password – for connecting to an Oracle Database. This avoids writing hard code user passwords in a shell script or in an application database configuration file. A wallet can also contain certificates – for example for […]

Preparation for migrating data to Oracle Virtual Private Database

Jacco Cijsouw

  preparation for migrating data to Oracle Virtual Private Database Introduction Recently I was part of a team involved in the preparation of migration data belonging to multiple business units into a single Oracle 19c database with Virtual Private Database (VPD). The VPD solution is used for the virtual separation […]

How to unit test a SQL query?

Lucas Jellema 7

A simple challenge: I am working on a SQL query. Not a trivial query. I am trying various approaches. I believe I may have found a solution that works. That produces the correct solution. How can I be sure? How can I try to further refine the query while maintaining […]

How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (6)

Gert-Jan Paulissen 1

Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)”, I told you about Git, Subversion, Maven and Flyway. In this final article, I will discuss the following tools & methods: Oracle SQL Developer, utPLSQL, SonarQube, Perl, Ant and DevOps. Oracle […]

How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)

Gert-Jan Paulissen

Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)”, I told you about the Oracle SQL Developer Data Modeler. This time I will discuss the following tools: Git, Subversion, Maven and Flyway. Flyway The first tool I would like to […]

How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)

Gert-Jan Paulissen

Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)”, I told you about the Oracle Database and Oracle APEX. This time I will discuss Oracle SQL Developer Data Modeler. Oracle SQL Developer Data Modeler A book I can recommend is Oracle […]

How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)

Gert-Jan Paulissen

Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)”, I did show you the database structure. This time I will elaborate on the base tools, the Oracle Database and Oracle APEX. Oracle Database How to use it? I can tell […]

How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)

Gert-Jan Paulissen

Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (1)”, I gave you an introduction. This time I will elaborate on the database structure. Project folder layout The following top level directories may exist for every database application project: Directory Description […]

Monitoring Oracle Database using Prometheus

Lucas Jellema 1

Prometheus is a very popular framework for gathering metrics from a plethora of runtime components, recording, analyzing, visualizing them and making them available for companion technologies such as Grafana. Prometheus harvests information from ‘exporters’ – processes that expose an HTTP endpoint where Prometheus can scrape metrics in a format that […]