Oracle Critical Patch Update — July 2010
July 15th, 2010 — 7:51am
The Critical Patch Update for July 2010 was released on July 13, 2010. Oracle strongly recommends applying the patches as soon as possible.
More information here.
OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050) – Errata
June 7th, 2010 — 2:31pm
There is a errata sheet to the book OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050) by Sam Alapati.
Continue reading »
11gR2 – empty tables skipped by export (deferred segment creation)
April 9th, 2010 — 3:08pm
If you still use the good old export utility, you probably have noticed that empty tables are not exported by the exp utility.
You can test it by simply creating dummy table (don’t insert any data into it) and then try to export the table.
Continue reading »
Manual Database Vault Administrator application deployment
March 12th, 2010 — 11:58am
Database Vault Administration (DVA) could be deployed manually by following steps.
First you have to stop dbconsole (from OS)-
emctl stop dbconsole
open the file $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_service_name/config/server.xml
and add the following line before the </application-server> element:
Add Database Vault to existing Oracle installation
March 11th, 2010 — 3:12pm
If you have already installed Oracle Server without database vault (DV) option (database vault is a option from Oracle Enterprise Edition). If you want to add DV to the existing Oracle installation, follow the steps below.