renaming a database

I tried poking around this newsgroup archives and docs to see how to rename a database...

I tried doing: alter database <name> rename global_name to <newname>

which claimed to have succeeded but didn't seem to do anything...

So I tried manually moving all the files and replacing all occurrences of <name> with <newname> but now when I startup the database I receive an ORA-01103 error that the database name doesn't match the database name in the control files.

Is there a way to change the database name in the control files at the point i'm at? Otherwise if I go back and rename everything to the original database name and get that started-up, how do I correctly go about renaming the database?

on a (slightly) related note, what's the 'proper' method for deleting a database and associated instance completely?

Thanks in advance,
Lee Received on Tue Jun 13 2000 - 00:00:00 CDT