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 »

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 »

PSU simplify Oracle patching

August 19, 2009 by 2 Comments 

What are Oracle Patches?

Oracle patching is not always straight forward. Patch sets, patch bundles, one-off and interim patches, critical patch updates,… so many product version numbers. What should I install on my Oracle systems and how often?
Read more »

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