Unable to DDL due to Oracle Spatial and XDB

October 30, 2009 by 1 Comment 

I’ve just encountered an interesting Oracle database issue that was not described properly on the Internet. So, I’ve decided to give a solution in this post.

The issue is that you simply can not execute certain DDL (Data Definition Language) SQL statements due to the strange behavior of Oracle triggers and Oracle error ORA-00604 and ORA-04098. Read more »

What makes an Oracle consultant tick?

October 21, 2009 by Leave a comment 

Oracle Open World in Berlin

Oracle Open World in Berlin

What makes me, as an Oracle consultant, tick? That question sometimes rises in my mind. I think the answer is “Passion for new IT technology, in particular new cutting-edge database techniques and features I have to learn and use at work. I would also include new training and conferences.

I can admit that my motivation sometimes wanes doing day-to-day DBA work but once I get a new and interesting project or have to work with brand new RDBMS versions I’m re-invigorated. Training and conferences are also big motivation driving factors for Oracle experts. Read more »

Oracle complete recovery using backup control file

September 29, 2009 by 2 Comments 

I was just called into an Oracle database recovery issue. The situation was trivial for an Oracle DBA – a media failure damaged just one DB file on the Oracle database operating in ARCHIVELOG mode.

…but the guys have already issued the following recovery statement by mistake:
Read more »

The power of Oracle User Dictionary Views

September 4, 2009 by 4 Comments 

“What’s my Oracle user default tablespace? How much space do my database objects occupy? Did you move all my indexes during the user schema copy?…”

Being a full-time Oracle DBA I frequently answer these same questions of software developers. Read more »

Find duplicate rows in Oracle table

August 25, 2009 by 4 Comments 

You are an Oracle DBA or developer and want to determine the location of duplicate rows in an Oracle table. You need it for example before attempting to place a unique index on the table. See below how can this be done.
Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email