| raj |
Posted: Aug 08, 2007 09:27:56 PM |
Total Post: 15
Joined: Aug, 2007
|
| i want to change my db name but my parameter file is pfile hw can i change the name |
|
|
Mohammed Taj |
| Posted: Aug 09, 2007 12:53:17 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
for this you have to follow procedure.
http://dbataj.blogspot.com/2007/04/changing-only-database-name.html
and for pfile...you should create SPFILE from pfile through below statement.
conn with dba user in SQL PLUS PROMPT
create spfile from pfile
shutdown immediate
startup
Regards
Taj
http://dbataj.blogspot.com
|
|
|
|
|
jogi |
| Posted: Aug 29, 2007 02:23:37 PM | |
|
Total Post: 21
Joined: Jul, 2007
|
database name can be changed by using the nid utility.
nice user='sys as sysdba' dbname=xyx set=y ;
cheers
prasad
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |