• About Me
  • Contact
  • Linux
  • Oracle
Wadhah DAOUEHI
Wadhah DAOUEHI
Oracle and Linux blog
LinkedIn YouTube Twitter
  Menu
Skip to content
  • About Me
  • Contact
  • Linux
  • Oracle
LinkedIn YouTube Twitter
LinkedIn YouTube Twitter

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
Dealing with INVALID status of Oracle database components after upgrade to 12c (12.1.0.2)

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 →

  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • Database 19c Vault: OWNER/Manager privileges !
    • Enabling the Database Vault (Initialisation parameters)
    • [FATAL] [DBT-09352] Error in validating dbv_owner credentials.
    • Oracle 19c: Convert Table to range partition online
    • Oracle 19c: Automatic List-Partitioned Table (2/2)
    • Oracle 19c: Automatic List-Partitioned Table (1/2)
    • Oracle 19c: Interval Partitioning (2/2)
    • Oracle 19c: Interval Partitioning (1/2)
    • Oracle Database 19c: Shared Server mode
    • SYS.DBMS_BACKUP_RESTORE & SYS.DBMS_RCVMAN RMAN
    • Oracle 19c: pdb_storage_clause
    • NGINST-64051: Invalid Central Inventory location “null”.
    • 23ai: Create table if not exists
    • 23ai: Direct join with DELETE
    • 23ai: Direct join with UPDATE
    • 23ai: BOOLEAN Column Data Type <Enhancement 02>
    • 23ai: BOOLEAN Column Data Type <Enhancement 01>
    • 23ai: Having with alias
    • Create FREE 23ai Database
    • Oracle Database 23ai installation RPM
    • Oracle Database 23ai Preinstallation RPM
    • 23c: Oracle database: Close in steps
    • 23c: Database has been previously opened and closed
    • Get OEMCC 13c5 Agent zip file (Windows)
    • Error Installing Oracle cloud control 13c5 on Windows Server 2016
    • Enable LOCAL_UNDO for PDBs
    • ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
    • Create an Oracle Database 19c using SQL
    • Can’t locate Term/ReadKey.pm
    • Reason = profile limit idle_time
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter