Blog
The Café Database Blog
Multilingual sorts in Oracle
Oracle allows text to be sorted according to the linguistic rules of each language. It’s important to understand that each writing system follows different collation rules. For example, in Norwegian, there are three characters that don’t exist in the standard Latin...
Bring your impdp some love
Imagine you're planning a database migration between two servers. You're performing a FULL import into a brand-new DATABASE. You have plenty of good reasons to "reorganize" the entire DATABASE: a SYSTEM tablespace over 60GB, a SYSAUX tablespace exceeding 40GB... you...
How to build a chain of jobs with DBMS_SCHEDULER
A few days ago, in the Café Database Discord Server Administration channel, someone asked how a chain of job executions could be implemented with DBMS_SCHEDULER. The idea is that when a task finishes, it waits two minutes and runs again. The problem is that the...
SPOUG2024 chronicle
I’m writing these lines on my way back to Valencia after attending the annual SPOUG event in Madrid. The Oracle Users Group of Spain has grown strong, and the event was centered around six conference rooms where, simultaneously, a series of talks and presentations on...
Upgrade your database DST… or not?
In 2019 they decided in Chile that the winter time adjustment would be 5 months, instead of the usual 3 months. Morocco also decided to move its time with respect to GMT from +00 to +01. These changes that you may think do not affect you in the least, unless you live...
Leap years in the Oracle database
Leap years have been a headache throughout history. Also for computer systems and databases.
Discover the origin of these problems and let’s take a look at date bugs that are still present in Oracle23c