hardy@lso

So, here are some links that helped:

http://blogobaggins.com/2009/06/23/native-oracle-on-osx.html

and THIS

http://blog.rayapps.com/2009/04/12/how-to-install-oracle-database-10g-on-mac-os-x-intel/

That last link is really super important, as apparently the official installer from Oracle sets you up with a cranky-non-functioning version of the oracle executable, and Ray totally has you covered, and provides a working link to an older version of the exectuable. Sounds fishy, you say? Apparently the Oracle folks don’t think so, they link to this blog posting.

I dunno why it’s this hard. I guess it just has to be.

I had to come up with this because Excel doesn’t have a built-in way to look at mixed storage values (i.e. 1MB, 30GB, 1.2TB etc.). So, I cooked up this function:

= IFERROR(VALUE(IF(RIGHT(A2,1)="M",LEFT(A2,LEN(A2)-1)/1024,
IF(RIGHT(A2,1)="T",LEFT(A2,LEN(A2)-1)*1024, 
IF(RIGHT(A2,1)="K",LEFT(A2,LEN(A2)-1)/1024/1024, 
LEFT(A2,LEN(A2)-1))))), 0)

You’d need to tweak that a bit if you had two-character units (GB, MB, TB, KB), but I just had one-character units, produced by this Linux command: du -sh *