• About
  • All Posts
  • The Podcast!
  • 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
  • The Podcast!
August 27, 2012 Uncategorized

ORA-32033: unsupported column aliasing

When you see this SQL> with xyz 2 ( 3 select 1 my_alias from dual 4 ) 5 select *

Continue reading

August 19, 2012 Uncategorized

InSync12

If you are in Melbourne this week, hopefully you’ve registered for the InSync conference (www.insync12.com.au), which is the main user

Continue reading

July 18, 2012 Uncategorized

ORA-28511: lost RPC connection to heterogeneous remote agent

A client has been seeing this error when holding sessions open over HS for lengthy periods of time (greater than

Continue reading

July 18, 2012 Uncategorized

bitmap indexes… better in new versions

“Back in the day”, bitmap indexes on tables meant any kind of DML was going kill you either for the

Continue reading

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

Posts navigation

«Previous Posts 1 … 68 69 70 71 72 73 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.

Tweets by connor_mc_d

    Top Posts & Pages

    • SQL engine and PL/SQL functions
    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • No more stale statistics in 19c
    • A new use for DML error logging
    • How to TREAT data in a CLOB as JSON
    • How to generate random unique values
    • Getting a dog improved my productivity
    • Automatically generate audit capture for tables
    • Archives
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 847 other followers
      • Already have a WordPress.com account? Log in now.
      • Learning is not a spectator sport
      • Customize
      • Follow Following
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar
     

    Loading Comments...