Keep It Simple. Developer's tips.

Synchronize your existing environments and start using SQLcl Liquibase - part 3

Sep 19, 20234 min read 71 views

In previous parts, you've learned how to start using SQLcl Liquibase with a new database and then track your database changes made after. In this...

Synchronize your existing environments and start using SQLcl Liquibase - part 3

Step-by-step guide. Oracle's expdp/impdp commands to exclude/include objects and mask sensitive data (on-premise)

Jul 26, 20233 min read 161 views

Let's say I had to refresh my development or uat server with production data (all my servers are on-premise). Why? For easier debugging or developing...

Step-by-step guide. Oracle's expdp/impdp commands to exclude/include objects and mask sensitive data (on-premise)

Track your DEV database changes using SQLcl Liquibase and move it to UAT - part 2

Jul 7, 20233 min read 200 views

In the previous episode, we learned to capture all objects from the DEV schema and move them to UAT. In this part, I will make a few changes on DEV...

Track your DEV database changes using SQLcl Liquibase and move it to UAT - part 2

SQLcl Liquibase - generate-schema enhanced. Capture only new changes since provided date.

Jul 5, 20231 min read 47 views

SQLcl Liquibase generate-schema command is excellent (read more here) But what If I don't want to capture all my objects repeatedly? I want to...

SQLcl Liquibase - generate-schema enhanced. Capture only new changes since provided date.

Oracle SQLcl's new feature - save connections. Finally, I can use it as often as I'm using SQL Developer.

Jul 5, 20232 min read 201 views

Do you know what always annoyed me about SQLcl? Manual input of my database details, such as connection string, username, and password. I've always...

Oracle SQLcl's new feature - save connections. Finally, I can use it as often as I'm using SQL Developer.

Essential tips for freeing up storage in Oracle Database XE

Jun 16, 20233 min read 328 views

I will share some practical tips and scripts that helped me to reclaim valuable space in my Oracle Database XE environment (12 GB limited space) It...

Essential tips for freeing up storage in Oracle Database XE