Install Oracle 11G Release 2 (11.2) on Centos 6

This article presents how to install Oracle on Centos 6.

Read following article how to install Centos 6 Linux: Install Centos 6 (allocate 64G for disk and set 2G memory for your virtual machine before proceeding with Oracle software installation).

Check latest article How to install Oracle 12C (12.1.0.1) on Centos 6 with UDEV disks, NFS disks, kmod-oracleasm library

Continue reading

Exchange partitions for compressed table and unused columns ORA-39726, ORA-14097

This article presents problems related to ORA-39726, ORA-14097 on compressed table.

In case you want to drop a column on a compressed table (partitioned or not) you can encounter following error:

ORA-39726: unsupported add/drop column operation on compressed tables

This error can occur for following type of compression:

  • batch compression
  • EXADATA compression

Exception is OLTP compression – drop is working here. You can read about compress OLTP here – Table compression in 11G

Continue reading