Author Archives: George Valentin Voina

#Oracle 12c invisible columns

By | February 20, 2021

“Invisible columns”: This is a new feature introduced in Oracle 12c that got me all excited.In short you can now have hidden columns in a table that are not visible to the standard SELECT, INSERT clauses if you do not want to. Some usage for this: Legacy application queries I hate how you have to… Read More »

#CrowdSourcing and #DataMining the new resource mining, or how big corporations are robbing you blind.

By | September 30, 2017

The newest commodity this days is crowd sourced data. All the digital corporations push this envelope harder and harder. Google wants to make me a “local guide”: post images of places on google maps and review businesses for free of course (they give you a badge, you know like boy scouts badges). This is lately… Read More »

Blog Links: Project management: A surefire way to kill your software product

By | September 27, 2017

One of the best articles about project management and software development Project management: A surefire way to kill your software product. As a software developer I have to agree with almost everything stated there and I can confirm most of it as true. You cannot treat creative people as resources and think that inspiration and… Read More »

Set up automatic #Oracle database back-up using #RMAN

By | September 19, 2017

There is a very easy method of setting up on Linux an automatic back-up for Oracle by using database procedures, RMAN and scripts. STEP 1: Define a back-up script Create in /home/oracle/backup.sh a script file with the content: #!/bin/bash export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin export ORACLE_SID=prod rman target / CMDFILE=/home/oracle/bin/backup.rman LOG /data/oradata/backuplogs/rman-`date -I`.log exit 0 Where… Read More »