Month: October 2011

HBase has disappearing rows

I guess this may have a place if your application data is transient in nature and doesn’t need to be retained forever. We first take an existing table and for a given column family set its “time to live” to…

11g compiler warnings

The PL/SQL compiler warnings have been enhanced in 11.2.0.1 and up to include a warning for the dreaded “when others then null” exception handler. Actually, the warning is raised any time an “others” is handled (even if it is logged…

Simple example of a type stored in a table

Nothing fancy today, this is just a placeholder for using object types as a column in a table. SQL> create type mytype as object (p_name varchar2(20),p_age number); 2 / SQL> create table type_table(c mytype); Table created. SQL> insert into type_table…

Disabling LOGGING on a LOB

In Oracle 10.2.0.4, we were doing a large data migration of archive records. Initially, we could recreate the data from the source, so our plan was to: copy rows nologging to destination database backup destination database truncate tables in the…