Author Archives: Bobby

I ran this query with a hint: I ran this select to get the plan: I was getting this error: Column Projection Information (identified by operation id): 1 – “BLOCKS”[NUMBER,22] ORA-00904: : invalid identifier I found that my user or … Continue reading →

I want to document some recent steps that I have been taking to support new development on a transactional system. Every time the system has a new release, if that release includes Oracle SQL changes, I am asked to create … Continue reading →

Just a quick note about two tools I use: TextPad – my favorite text editor. I know everyone has their own, but this is mine. UnixUtls – Unix like tools on a Windows command line. Bobby P.S. I need to … Continue reading →

I have been having trouble using WordPress on this blog. I keep having long lines wrapped instead of having a slider that readers can use to see the end of the lines. Also, pictures that looked fine when I posted … Continue reading →

I posted a question about this and didn’t find an answer. I searched both Oracle’s support site and the internet in general. I ran the DBVERIFY utility dbv against a bigfile datafile that had corrupt blocks and wanted to relate … Continue reading →

It looks like this blog is costing me about $6 per month on AWS which is cool. I was paying about $200/year or about $17 per month on iPage. I am not sure what I am missing. This blog is … Continue reading →

Most of my work is with Oracle databases but I have been starting to learn a little bit about MySQL. Where I work, we have a bunch of on premises Oracle databases including large and active ones with various challenging … Continue reading →

I was using Centos Linux for Nethack programming and playing on my home laptop. Evidently Centos is going away at the end of 2021 and Tim Hall had a post about moving Centos to Oracle Linux. So, I did it. … Continue reading →

It has been two years or more since I first thought about moving my blog to Amazon Web Services (AWS) from iPage, the hosting company that this blog has always been on. My company uses AWS for a number of … Continue reading →

I have more to do but I have bobbydurrettdba.com pointing to an Amazon EC2 virtual machine. Seems faster. I still have email forwarding done on iPage and they still have the domain registration and dns. I plan to work on … Continue reading →