Home » RDBMS Server » Server Administration » ORA-00200: control file could not be created
ORA-00200: control file could not be created [message #208499] Mon, 11 December 2006 01:37 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
CREATE DATABASE orcl
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: 'C:\ORACLE\PRODUCT\ORADATA\ORCL\CONTROL01.CTL'
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists


controlfile is there but while creating database it fails. Where to mention REUSE option while creating the database. ??

Report message to a moderator

Re: ORA-00200: control file could not be created [message #208514 is a reply to message #208499] Mon, 11 December 2006 02:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,


ORA-00200: control file could not be created

ORA-27038: created file already exists

First Delete all control files.
then
execute "create database statement"


hope this helps
Taj

[Updated on: Mon, 11 December 2006 02:48]

Report message to a moderator

Re: ORA-00200: control file could not be created [message #208529 is a reply to message #208499] Mon, 11 December 2006 04:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you check the docs?
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/img_text/create_controlfile.htm

Report message to a moderator

Previous Topic: Error 367 Crystl32.ocx problem
Next Topic: Information about dump in the Oracle, please help me to find...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:34:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.