Managing Oracle

This blog is about Managing Oracle databases, a day-to-day job for many.

Monday, January 27, 2025

Remove a lot of data from a table (4 ways)

Deleting old historical data or test data from a database is one of these DBA jobs that may be boring, but may also need sufficient attentio...

Generate Reset Password statements

A lot of companies we as DBA's work for have Test- and Development databases that are based on a copy of a Production database. Every t...

Wednesday, January 22, 2025

Password rollover time

A new security feature announced for Oracle 23ai has been back ported to 19c as of RU 19.12. The feature offers the possibility to keep usin...

Thursday, January 9, 2025

Restore database from NFS storage

In this blog the restore of an Oracle database is described. The database was, before it got lost, daily backed up to an NFS mounted storage...

Wednesday, July 10, 2024

Runinstaller -silent on AIX not so silent at all

A short blog-entry about running an unattended installation of Oracle 19c on AIX. With previous releases we have never seen this issue where...

View web version

About Me

FJ Franken (DBA): I am FJ Franken, a DBA for a large European Retail company. I have been a DBA since 1997. I like working with Oracle databases, because it's a challenge for me to know all aspects of the database and its behavior.

View my complete profile

Powered by Blogger.