The Real Sartograph, Lord of Sherwood Forest & Kingswood

EBR is also handy for some structural changes, but requires that the application uses editioning views and clean API packages (smart/pink DB).
But usually in reality you will encounter direct table access from applications. 😅

The biggest takeaway imho is to break deployments into small steps (expand/contract), even if they belong to the same feature. This makes it easier to "undo" stuff or even spot the problem.

Instead of undoing all prior steps, repairing the order, and then doing everything again,

you would just go forward by repairing the order of the remaining steps.

Also, rollback scripts in automated fashion will usually undo every part of the deployment, which might consist of several changes.
A forward fix could focus only on the part which went wrong. Maybe your script just tried to create a FK and the table was not yet existing due to wrong ordering.

So you could just run the failed update script again at a later point as the same version.

Whereas a forward fix is a new deployment (with usual syntax). So you could not run the original patch again and would have to create a new unique changeset to retry the original change.

I think from DB perspective (DDL/data state) the achieved end result of "undoing" is the same.
The difference is the execution with the tools (ie Flyway/Liquibase). Rollback scripts have a special syntax/tags and I think the tools then treat the initial script as "has not been applied".

Warum heißt es eigentlich alte Blätter und nicht Ur-Laub?

Wieso heißt eigentlich Schlumpfkacke und nicht Kot d'azur?

Datagnan and the 3 Musqleteers:
DBAthos, Ratio_to_Reporthos and AWRamis

Code snippet showing Oracle qualified expressions do not work when using subtypes

That is 19c.
Would be so nice if this worked.

Wieso heißt es eigentlich Samenbombe und nicht Grünate?

Wieso heißt es eigentlich Farbpalette und nicht Klecksikon?

Wenn man keine kleinen, kläffenden Hunde mag... ist man dann intölerant?

Es könnten morgen alle ausreisepflichtigen Menschen ausgewiesen sein und für niemanden hier wäre auch nur irgendwas besser.
Wohnraum wäre weiter unbezahlbar, mehr Pflegekräfte haben wir davon auch nicht und in der Schule tropft es weiter durch die Decke.
Das ist NICHT unser Hauptproblem.

Wieso heißt es eigentlich Baum und nicht Zweigstelle?

Permission Concept for Database CI/CD in the Oracle Database CI/CD changed how we manage and deploy database changes. This article explains how to set up application- and deployment users correctly.

After my last blog post, a discussion started about user permissions and CI/CD. So, I wrote a short story about the problem that occurs when using a schema user for application access or in database schema deployments.

@oracleace.bsky.social

medium.com/@jasminfluri...

Maybe proxy user would be a good option for the deployment user. Then it doesn't need powerful permissions, we can just grant connect through, maybe even limited to a specific role with only the necessary subset of the schema user permissions.

I often need to do DML as part of deployments, i.e. data migration, or data "fixes".
I think for audit it is important then that the developers don't have access to the schema users, but only the deployment user, so they can't "go around".

I totally agree with the application user. But could you explain how you would setup the deployment user? Wouldn't it need some CREATE/ALTER/DROP ANY privileges? Then it would be an almighty all-in-one schema-user. How is that better than the schema users directly?

YouTube video by Joko & Klaas Robert Habeck, Friedrich Merz und Olaf Scholz über #PolitikUndAnstand | Joko & Klaas 15 Minuten

Schadet nicht, sich das anzuschauen:
www.youtube.com/watch?v=qfYb...

Looking for daily SQL tips, esp when working with Oracle?

Look no further, just follow
@sqldaily.bsky.social

Nach einiger Klokrastination heute endlich die verstopfte Toilette unter intensiver Anfeuerung der Frau entstopft.

Sie ist eine wahre Pömpelmuse.

Das Erfolgsformat "AskTom" von #Oracle ist nun auf @bsky.app vertreten:

@oracleasktom.bsky.social

cc/ @chrisrsaxon.bsky.social @connormcd.bsky.social

A plush oracle database wearing a flat dumbledore hat and a unicorn hand puppet as a beard

Next time I will do that!

For now I came up with... *drumroll*

DBledore!

I even created a fancy dress as suggested by @kibeha.dk
I made sure to leave a lot of room for improvement.

So I need to find a name for my new partner, too.
Do I go with a modern name like Cloudia or Vectoria?
Or something like Rowland, Bufferdinand, Truncatherine, Schemantha or CurrValery?