Category Archives: SQL

save SQLPLUS commands history on Linux within the package rlwrap (readline wapper).

By Wadhah DAOUEHI | August 3, 2016 - 4:42 pm |June 1, 2018 Linux, Oracle, SQL

Leave a comment

This article explains how to save SQLPLUS commands history on Linux within the package rlwrap … Read More →

Dealing with INVALID status of Oracle database components after upgrade to 12c (12.1.0.2)

By Wadhah DAOUEHI | August 31, 2015 - 11:38 pm |June 1, 2018 Linux, Oracle, Oracle Database, SQL

Leave a comment

This article deals with INVALID, OPTION OFF status of Oracle database components AMD, ORDIM, JAVAVM, … Read More →

Active Oracle database duplication

By Wadhah DAOUEHI | November 20, 2014 - 10:49 pm |June 1, 2018 Linux, Oracle, Oracle Database, SQL

Leave a comment

This article explains how to set up an Active Oracle database duplication with the RMAN … Read More →

Database SQL; Delete vs Truncate and segment size allocated

By Wadhah DAOUEHI | August 31, 2014 - 10:24 pm |June 1, 2018 Oracle, Oracle Database, SQL

Leave a comment

This article shows the differences between SQL commands delete and truncate in Oracle Database with … Read More →