Jeff:
I tried but I am getting the same error as before.
Also, when you change the db_name why do I need to do resetlog?
Thanks.
Printable View
Jeff:
I tried but I am getting the same error as before.
Also, when you change the db_name why do I need to do resetlog?
Thanks.
Check metalink ( http://metalink.oracle.com/metalink/...atabase_id=NOT )Quote:
Originally posted by ora_inf
Jeff:
I tried but I am getting the same error as before.
Do you need to open resetlogs? No, probably not. I do it because I have just changed a major parameter of my database. Also, that's the way Oracle recommends to do it (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=15390.1 )Quote:
Also, when you change the db_name why do I need to do resetlog?
Jeff:
I read the document and check config and init files as suggested. I could not find any ref. old database name.
When I tried "alter database rename....", did not work. I am getting the same error.
I am using oracle 8.0.5
Thanks.
Not really sure what to tell you. I have done it may times myself. The syntax for alter database is at ( http://technet.oracle.com/doc/server...4a.htm#1980962 )
Jeff:
You are right..It worked. I was replacing global_name with
my old database name.
Thanks lot....