Home » RDBMS Server » Server Administration » Database creation
Database creation [message #230662] Thu, 12 April 2007 09:29 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Database creation [message #230670 is a reply to message #230662] Thu, 12 April 2007 09:56 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Thank you very much, Harshad.
Re: Database creation [message #231009 is a reply to message #230663] Fri, 13 April 2007 12:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Your db name should be of 8 characters only, you can not put more then 8 characters


You can create more than 8 character DATABASE_NAME not INSTANCE_NAME/SERVICE_NAME/ORACLE_SID it is must in 8 character.

or you can rename dbname through DBNEWID utility.

Regards
Taj
Re: Database creation [message #231560 is a reply to message #230662] Tue, 17 April 2007 09:12 Go to previous message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Thanks,Taj.
Previous Topic: crsd.bin
Next Topic: Finding forms user name/form name
Goto Forum:
  


Current Time: Mon Dec 02 08:36:41 CST 2024