Uncategorized

Installation of postgresql-13.1-1 fails on windows fails with “Failed to load SQL modules into the database cluster” & “Problem running the post-install step. Installation may not complete correctly.”

Dear Readers, Happy new year 2021!!! This is my first day of learning PostgreSQL and I faced issue while installing version 13.1 on windows. After almost spending 3 hours of troubleshooting I was able to identify the issue & fix it. In this post will explain basic steps to install […]

Drop empty tablespace fails with ORA-14404 or ORA-144047 partitioned table contains partitions/subpartitions in a different tablespace

Recently I was performing database reorg operation on one of pre-prod environment with traditional way of table/lob movement followed by index rebuild. After moving all segments from current tablespace to new, I was ready to drop original one. SQL> select count(0) from dba_segments where tablespace_name=’MY_TABLESPACE’;   COUNT(0) ———-      […]

2015 in review

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 22,000 times in 2015. If it were a concert at Sydney Opera House, it would take about 8 […]

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: A New York City subway train holds 1,200 people. This blog was viewed about 4,400 times in 2014. If it were a NYC subway train, it would take about 4 trips to carry that […]