Author: Marcos Siqueira

Using SQLCODE Function

The idea of this post is to show how to handle errors using SQLCODE function. That function shows the code error for the latest exception when running a PL/SQL code. Here is a small example of code that raises an…

Read More >

How to fix dbupgrade script issue when upgrading Oracle Database Standard Edition

Objective: Upgrade Oracle database from 11.2.0.4 to 12.2.0.1 During the Oracle database upgrade process from 11.2.0.4 to 12.2.0.1 (Standard Edition), running on Windows Server 2012 R2 64bit, the following error was found while executing the dbupgrade script. C:>dbupgrade LOG FILES:…

Read More >

How to install Vertica for test purposes

The column-oriented Vertica Analytics Database Platform was designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. The following instructions show how to create a Vertica database…

Read More >