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 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 »
…but the guys have already issued the following recovery statement by mistake:
Read more »
“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 »