Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change case of database name

oraLaroApr 12 2013 — edited Apr 12 2013
Its a display thing in the EM, 50 databases all in lower case, someone had created a database in uppercase so in a tidy up operation I was asked could I change the case to lower. no problem, I'll use nid
SQL> select name from v$database;

NAME
---------
JUPITER
startup force mount and use nid to rename the database

nid target=sys dbname=jupiter setname=yes

get error

NID-00144: New name for database JUPITER is the same as current name JUPITER

hmm, ok, maybe try in double quotes

nid target=sys dbname="jupiter" setname=yes

same error

NID-00144: New name for database JUPITER is the same as current name JUPITER

Is there some trick to this without having to recreate database from controlfile?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2013
Added on Apr 12 2013
4 comments
1,221 views