WTF?!
Isn’t that a nice error message: Tue Jan 22 05:47:15 2008 Propagation Schedule for (AFC999DDA45.LAJK, AFC999DDA45_REMOTEDB) encountered following error: ORA-00000: […]
Uncategorized
Oracle
Misc
11g and the new SecureFILE LOB data type (simple quick test)
As I had to run some comparison test Oracle 10g and 11g I also did a little test with the
Uncategorized
Test your Oracle knowledge
Just found in H.Tonguç YILMAZ Oracle Blog: Test your Oracle knowledge Some questions seem to be a little bit obsolete
Uncategorized
Oracle partner regulars’ table
Yesterday I joined the Oracle partner regulars’ table in Arcotel in Linz. It was nice to see a known face
Misc
Prepared statement in batch mode vs. FORALL in PL/SQL
A few days ago I had a nice discussion with one of our developers here in the office. The subject:
Uncategorized
When the database dies….
Yesterday was a bad day for me as DBA. All begone with two distributed transactions which had a lock held
Uncategorized
Oracle Open World 2007
Yesterday OOW 2007 started and I can’t join it. 🙁 It’s taking place in San Francisco. Well I hope next
Technology
Oracle partner network – technical training…. nearly
Oh man, yesterday an email arrived to join a technical training provided by Oracle partner network on the 27th of
Uncategorized
SYS not almighty!?
I always thought that SYS is the almighty user of the database like root on linux OS. But it seems
Uncategorized
The beauty of Java stored procedures
Since 8i you can write stored procedures also in Java. But what is the advantage of writing a procedure in
Uncategorized
Today Oracle 11g and tomorrow… the whole world
Finally the time has come. I’m currently installing Oracle 11g on a test-box (thanks to my Admin for the box!).
Misc
BULK COLLECT & FORALL vs. CURSOR & FOR LOOP
After more and more reads about BULK COLLECT and FORALL and their performance improvements I decided to have a closer