On associativity, transitivity and reflexivity

Addition is supposed to be associative. a+(b+c)=(a+b)+c This may be wrong in Oracle when dealing with months and days with t as (select interval ‘1’ month a, date ‘2007-09-26’ b, interval ‘7’ day c from dual) select a+(b+c),(a+b)+c from t; A+(B+C) (A+B)+C ———– ———– 03-NOV-2007 02-NOV-2007 The equality is supposed to be transitive if (a=b […]

installing OID 10.1.4.2 Preview 1

Download oracle-oid-10.1.4.2.0-1.0.i386.rpm Download oracle-xe-univ-10.2.0.1-1.0.i386.rpm Install the rpm # rpm -i oracle-*.i386.rpm In SLES 10, there is no /bin/cut, let’s create a link as root to avoid a mistake when running config-oid.sh # ln -s /usr/bin/cut /bin/cut Run the configure script as root # /etc/init.d/oracle-oid configure That’s all folks! It created an Oracle XE 10gR2 database, […]

Oracle Database 11g: The Top Features for DBAs and Developers

I am always delighted to read the top features by Arup Nanda. He started his 11g series : Oracle Database 11g: The Top Features for DBAs and Developers There are many partitioning enhancements. The most exciting feature for me is the INTERVAL partitioning. A huge cause of downtime and waste of storage is the range […]