• About
  • All Posts
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
July 18, 2012 Uncategorized

dbms_hs_passthrough–the magic package

This is a package that you can call, that does not exist in the database. I found this out after

Continue reading

May 30, 2012 Uncategorized

Index size

I think this feature came around ages ago (10.2?) but I’m still always impressed by it every time I use

Continue reading

May 28, 2012 Uncategorized

Cute partition elimination trick

I have a large partitioned table called TXN and I want to find the most recent transaction recorded, where the

Continue reading

April 21, 2012 Uncategorized

Error when dropping user

Recently when trying to drop a user, I got an error that seemed unrelated to the act of dropping the

Continue reading

April 14, 2012 Uncategorized

Mark Townsend

RIP. A fine Oracle man.

March 14, 2012 Uncategorized

Insert after compress

This is a bug encountered at a client site, and the test script was carefully prepared by Mark Hoxey (http://markhoxey.wordpress.com/)

Continue reading

February 29, 2012 Uncategorized

Mount Wellington

21 kilometers …. all up hill.  Just up…and up….and up All on a bicycle

February 29, 2012 Uncategorized

Tasmania 2012

I did three talks for the tasmanian user group.  Its a small user group, but a credit to the committee

Continue reading

February 20, 2012 Uncategorized

Perth AUSOUG meeting

I’ll be doing a talk on Flashback on Feb 29.  Details below – hope to see you there.   Where:

Continue reading

February 20, 2012 Uncategorized

Calling all Oracle Tasmanians :-)

I’m in Hobart Tasmania for a half day on Monday (Feb 29).  If you’re in town, please drop in and

Continue reading

Posts navigation

«Previous Posts 1 … 55 56 57 58 59 60 Next Posts»

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • PL/SQL in 21c gets amazing new loop iterators
  • How to do a GRANT on an entire schema
  • New Year ... new idea ... new channel
  • Why you keep getting "ORA-01653: unable to extend table"
  • No more stale statistics in 19c
  • The death of UTL_FILE
  • APEX 20.2 comes to town (well, to my PC)
  • Connection shortcuts with a wallet
  • DBMS_JOB - watching for failures
  • How long will the script take to run?
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel