Blog

The Café Database Blog

Multilingual sorts in Oracle

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...

read more
Bring your impdp some love

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...

read more
How to build a chain of jobs with DBMS_SCHEDULER

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...

read more
SPOUG2024 chronicle

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...

read more
Upgrade your database DST… or not?

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...

read more
Leap years in the Oracle database

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

read more
Share This