Tags » Partitioning

Leading using CAP

John ‘CAP – the basis of any big data tool. I find many leadership principles in just these 3 characters’

Smith “What?’

John ‘Consistency – An entrepreneur needs to be consistent in thought processes’ 58 more words

Sample script to drop interval partitions

Situation:

The big benefit of using interval partition is automatic partition creation when new records are inserted. But we need purge the history partitions by developing inhouse scripts. 166 more words

Partitioning

ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

Situation:

We created an interval partition table structure only, then try to import the data from exported dump file. It causesĀ ORA-14300 error. The same error occures when insert records from another online backup table: 118 more words

Partitioning

Postgres - Partitioning Tables

Currently we are working on a project which contains a very large Postgres table (Postgres 9.2) with something like 60 million rows. Most queries on this table have become really very slow. 719 more words

Databases

Enabling/Disabling Database Options in Enterprise Edition

This is a pure licensing post, but it is really important for DBAs to know how to do it in a correct way, and I hope it will be useful for all of you. 686 more words

Database Options

App makes it easier and faster for surveyors, architects and designers to specify glass thickness

With smartphone and tablet use by construction professionals growing year on year, the Optima Glass Thickness Calculator App continues to make it easier and faster for surveyors, architects and designers to specify glass thickness in partitioning systems. 133 more words