Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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