Dropping a table during SELECT in oracle and SQL server

Uwe Hesse in his article Dropping a table during SELECT has described how dropping a table during select statement works in oracle database server. As per his post, you are able to drop while selecting from the table. In contrary to this in SQL server dropping a table while a select is running doesn't work. The drop statement is blocked by the select statement. Once the select statement is completed, the drop statement also completes.

Mission Critical: Database Design

A very good documentation on designing and implementing mission critical database. I found it quiet interesting though now far from what I normally do when designing a mission critical database. You can find the full document @ simple-talk.com

SOA governance

Adaption of SOA is more likely to succeed if you embark a good but simple SOA governance. The following white paper explains the approches and best practices towards acheiving good SOA governance. Read
SOA governcance

List of oracle Table Names and Rows

I was looking for ways of displaying table names and number of rows it hold. It took me a lot of time to figure out how this can be done. After nearly completing my script, I found a better script than the one I created and want to share it with you.

You can find the full script @List of oracle Table Names and Rows

Export oracle METADATA_ONLY

steps
1. create dump directory (CREATE DIRECTORY metadata_export AS '/opt/app/oracle';
2. make sure the directory has got read and write permssion
3. create shell script as follows
4. schedule the script to run

#!/bin/sh
. envfile.env
$ORACLE_HOME/bin/expdp \"/ as sysdba\" SCHEMAS=shcema1, schema2, schema3 content='METADATA_ONLY' directory=met
adata_export NOLOGFILE=Y dumpfile=metadata_export:metadata.dmp compression=metadata_only