Tag Archives: oracle

Clean #Oracle schema used space after an archival

By | May 13, 2025
0 Comment

When archiving a big database it is very important to free up space after that. After running the archival scripts that basically deleted old data from the production database, some extra steps were necessary to actually clean up the used space in the database. To first check how much space we still use after deleting… Read More »

Read text content of a blob in #Oracle SQL

By | May 13, 2025
0 Comment

Sometimes you need to inspect the content of a text blob in Oracle. Yes, if the content is not a text then this does not make sense, but often times we insert in a blob field a really long text like an XML content or JSON content of a document. What we need to do… Read More »