This post is all about making historical data read only in the data warehouse. By making historical data read-only the aim is to reduce stor...

Some Quick RMAN monitoring commands I find useful and their explanations 1. LIST commands To show the incarnation of the database after the ...

Oracle LOBs are great data types to store unstructured data like pictures, audio files and movies. LOBs can also store semistructured data l...

I wrote this test to better understand the use of RANK, DENSE_RANK and ROW_NUMBER Oracle analytic functions and Top-N querying. The beauty...

Long time now I have been looking for a Free Data Modelling tool which is from the Oracle breed but is not part of a gigabytes size software...