| Database creation [message #230662] |
Thu, 12 April 2007 09:29  |
plshelp
Messages: 205
Registered: January 2007
|
Senior Member |
|
|
HI,
Using, database configuration assistant,I created a new database on a user's laptop with database name as CORREST.(I tried dbname as CORRESTDEV, but it gave me error saying the database name should be between 1 and 8 characters).The user wants me to rename the database to CORRESTDEV.
Can somebody help me how to rename the database? Oracle is running on 9.2.0.1 and OS is windows XP.
Thank you,all.
|
|
|
|
| Re: Database creation [message #230663 is a reply to message #230662] |
Thu, 12 April 2007 09:33  |
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
|
Senior Member |
|
|
Hi,
Your db name should be of 8 characters only, you can not put more then 8 characters. If you want to rename your database you have to create controlfile in textual format and then edit with new db name and start up your database.
Regards,
Harsh
|
|
|
|
| Re: Database creation [message #230664 is a reply to message #230662] |
Thu, 12 April 2007 09:39 |
plshelp
Messages: 205
Registered: January 2007
|
Senior Member |
|
|
Hi Harshad,
Thanks for your reply.. Can you please tell me how to create control file in textual format? Is it by doing alter database controlfile to trace? and then renaming the database and starting the instance?
|
|
|
|
| Re: Database creation [message #230668 is a reply to message #230664] |
Thu, 12 April 2007 09:51 |
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
|
Senior Member |
|
|
Hi, Once you get your controlfile trace after that you have to shutdwon database and modify the text file like here below
REATE CONTROLFILE REUSE DATABASE "TIGER" RESETLOGS NOARCHIVELOG
to
CREATE CONTROLFILE SET DATABASE "LION" RESETLOGS NOARCHIVELOG
.... Make sure your database mode, either it's archive log or no-archive log mode.
Regards,
Harsh
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
