Need to do this task, here is my env:
Task: change the db name from abcd9 to abcd
Database: Oracle 11g R1 (Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production)
O/S: Red Hat Enterprise Linux Server release 5.4 (Tikanga)
can any one guide me to the best possible way to do this task.