International-dba.blogspot.com

Recently I have been asked to investigate the following error on an Exadata system. ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type Well, that’s simple I thought! Must be (d)NFS mounted storage, right...

To borrow a well-known saying, One-Day International Cricket is a game played by two sides for 100 overs…and then the Aussies win the World Cup. Something else that doesn’t seem to change much over time is SQL*Plus. The command line interface to Oracle...

When database flashback first appeared many years ago I commented (somewhere, but don’t ask me where) that it seemed like a very nice idea for full-scale test databases if you wanted to test the impact of changes to batch code, but I couldn’t really...

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online...

During this Oracle Database 12c new features series, I shall be extensively exploring some of the miscellaneous, yet very useful, new additions and enhancements introduced in the areas of Database Administration, RMAN, Data Guard and Performance Tuning...