Deep Pancholi

Find me on:

Recent Posts

Oracle: Export empty tables

By Deep Pancholi

When taking a database dump from Oracle 11g recently, I found that the export did not include tables that had 0 rows. The Oracle11g instance implements a space saving measure where if your table has no data, it will not be exported. Space is allocated only when you add data to the table.

Read More »

MongoDB JAVA Driver: QueryBuilder Class

By Deep Pancholi

I was recently assigned a task where I had to convert a SQL like where clause query into Mongo query on the fly. There are some good drivers available to do the same but they are not free. The best example is UnityJDBC but it was a bit expensive for our use case. The query needed to be super simple and we made the following assumptions:

Read More »

ORA-28001: The Password has Expired

By Deep Pancholi

Recently, I logged into an old DB user that I had created on my desktop after quite some time. It was an older version of our software and so when the Services team reported a bug, I wanted to spin up the instance and try to debug the reason for the error.

Read More »
COMMENTS