Home » RDBMS Server » Enterprise Manager » nid utility
nid utility [message #68742] Fri, 13 August 2004 02:17 Go to next message
Pratap Zope
Messages: 23
Registered: July 2004
Junior Member
Hi,

I am using Oracle 9i Enterprise edition on windows 2000.

For changing name of my existing database I want to use 'nid' utility. However my bin folder (d:oracleora90bin) does not have the required exe for 'nid'.

Please and suggest help me so that I can change name of my database.

(I have executed catalog.sql and catproc.sql.)

Thanks.

Regards,

Pratap

 
Re: nid utility [message #68746 is a reply to message #68742] Fri, 13 August 2004 02:44 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

On Win i dont think that utility would be there, but you can find it on some unix/linux stuff.

On win to change the database name just recreate the controlfile with new database name. To recreate the controlfile first issue :

alter database backup controlfile to trace;

It will create a create controlfile script in ur user_dump folder. Modify the script, change "reuse database" to "set database" and specify a new database name. Open the DB.

Best of Luck
Daljit Singh
Previous Topic: 10g EM DB Control Problems
Next Topic: change port
Goto Forum:
  


Current Time: Fri May 20 14:34:30 CDT 2022