"Adley" <adley194_at_gmail.com> wrote in message
news:1148633972.523245.165630_at_j33g2000cwa.googlegroups.com...
> Hi all,
>
> I don't usually work with Windows, so I don't really know what went
> wrong. I tried to create a database using command lines in Win 2000 but
> failed. After specifying the new instance name using the ORADIM
> command, I login to the SQLPLUS as SYSDBA and issue the database
> creation command.
>
> Below is my CREATE DATABASE command:
>
> CREATE DATABASE adley
> CONTROLFILE REUSE
> LOGFILE
> GROUP 1 ('C:\ORACLE\ORADATA\ADLEY\LOG\LOG1.LOG') SIZE 100M,
> GROUP 2 ('C:\ORACLE\ORADATA\ADLEY\LOG\LOG2.LOG') SIZE 100M
> MAX INSTANCES 1
> MAX LOGFILES 10
> MAX LOGMEMBERS 5
> MAX DATAFILES 255
> DATAFILE 'C:\ORACLE\ORADATA\ADLEY\SYSTEM.DBF' SIZE 300M
> DEFAULT EMPORARY TABLESPACE TEMP
> UNDO TABLESPACE UNDOTBS DATAFILE 'C:\ORACLE\ORADATA\ADLEY\UNDOTBS.DBF'
> SIZE 100M
> ARCHIVELOG
> CHARACTER SET US7ASCII
> ;
>
> The error I received was the "Instance terminated; Disconnection
> forced" error. I use REUSE for controlfile because on my previous
> attempt, the controlfiles are already created.
>
> I've never encounter this problem when I'm creating databases on AIX or
> Solaris. Any ideas what went wrong?
>
> Thanks and Regards.
> =adley=
>
If that is the exact sql statement, you might want to change EMPORARY to
TEMPORARY.
--
Terry Dykstra
Received on Fri May 26 2006 - 09:46:00 CDT
