Tamil, I'm not sure that's good general advice. You could introduce an update that could not be rolled back . . .

ganga, if you can't redesign your tables, look here:
http://download-west.oracle.com/docs...13trg.htm#2634