Hey.
I am trying to create a DB with the following:
CREATE DATABASE testdb
USER SYS IDENTIFIED BY password
USER SYSTEM IDENTIFIED BY password
LOGFILE GROUP 1 ('D:\Oracle9\ora92\oradata\mynewdb\redo01.log') SIZE 50m,
GROUP 2 ('D:\Oracle9\ora92\oradata\mynewdb\redo02.log') SIZE 50m,
GROUP 3 ('D:\Oracle9\ora92\oradata\mynewdb\redo03.log') SIZE 50k
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'D:\Oracle9\ora92\oradata\mynewdb\system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'D:\Oracle9\ora92\oradata\mynewdb\temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE 'D:\Oracle9\ora92\oradata\mynewdb\undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
This is the error I am getting
ORA-01501: CREATE DATABASE failed
ORA-00301: error in adding log file 'D:\Oracle9\ora92\oradata\mynewdb\redo01.log' -
file cannot be created
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
Any ideas
Eoin