Wednesday, July 23, 2025

Recording of Reading Plans

 Hey folks!

Here is a link to the reading plans talk I did with Chris Saxon of Ask Tom Office hours last week.  

https://www.youtube.com/watch?v=WaqdsaepmY8

If nothing else this might be good to help you get to sleep.   😴 

Enjoy! 


Monday, July 21, 2025

Finally! Error messages that really help!

A rather huge problem in debugging queries over the years was the dreaded “ambiguous column” error.  It wasn’t something I ran into a lot, but when I did it always seemed to come up in rather large queries and was unbelievably hard to figure out which column. 

 

Now in 23ai we finally have an error message that at least gives a clue:

 

ORA-00918: CREATED: column ambiguously specified - appears in RVD_SCALAR_ALLUSERS and RVD_SCALAR_ALLOBJECTS

 

Apparently other error messages have also been enhanced to be more helpful as well.  I’ve personally not bumped into any of them just yet, but this is great news.

 

Well that only took about 100 years. 😏

Wednesday, July 2, 2025

I’ll be on Ask Tom Office Hours!

 I’ll be discussing how to read plans in Oracle on the 15th of July 2025.  Join in for a fun filled discussion about this fundamental skill for Oracle Professionals.  Register Here! 

See you there! 




Full link here in case the hyperlink doesn't work: 



https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=67493840316866131103361221956880470211&p2_join_yn=&p2_prev_page=3&clear=2&session=514799324044833&cs=1M0-Xs3clx05hEC13jfdZAc-IBLW2WgJOIo8pioS6UbbAeWfNGa8KHThFPZAAXcUaM43RD9P0FkA0JtpDexy-GA