Data migration is common. Moving data from one database to another, either via Datapump, Goldengate, unload/load scripts or some other method has risk. Did you move everything? How do you know everything was captured? How do you ensure the source and target data is the same? Exactly the same? You are going to have to…

Neil Chandler's DBA Blog

29.10.2024

Fundamental Security Part Nine – Scripted Passwords – Neil Chandler's DB Blog

October 2024 - Oracle 19C, 23ai Photo by Julius Drost on Unsplash So a while ago I spoke about passwords but forgot to mention a key element of account control in the blog. I was giving a talk on Security a few days ago and told an audience member that this information was in my…

Neil Chandler's DBA Blog

02.11.2024

Unlocking Insights: Why Conferences Matter – Neil Chandler's DB Blog

I very much enjoy speaking at conferences, and talking to everyone there. The insights that you get into how other companies are running their systems is incredible. The innovative approaches that different people and companies have to solving the same problems never ceases to amaze me, and the only way to really discover this. You…

Neil Chandler's DBA Blog

03.02.2025

Infinity – Old Oracle Numbers – Neil Chandler's DB Blog

A long time ago, Oracle had a couple of special numbers that you were allowed to store in a NUMBER datatype. They were Infinity and Negative Infinity! If you selected these numbers (using SQL*Plus) , they showed up as "~" and "-~", although it is worth noting that if you're using the funky modern sqlcl…

home›Neil Chandler's DBA Blog

Neil Chandler's DBA Blog

Software

Oracle Data Migration Validation – Neil Chandler's DB Blog

Fundamental Security Part Nine – Scripted Passwords – Neil Chandler's DB Blog

Unlocking Insights: Why Conferences Matter – Neil Chandler's DB Blog

Infinity – Old Oracle Numbers – Neil Chandler's DB Blog

home
›
Neil Chandler's DBA Blog