You don't need to put any Bracket after keyword 'LOGFILE'
See following lines...
CREATE DATABASE OHIR
LOGFILE 'D:\Oracle\oradata\OHIR\redo01.log' SIZE 1024K,
'D:\Oracle\oradata\OHIR\redo02.log' SIZE 1024K,
'D:\Oracle\oradata\OHIR\redo03.log' SIZE 1024K
MAXLOGFILES 12
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'D:\Oracle\oradata\OHIR\system01.dbf' SIZE 58M REUSE
AUTOEXTEND ON NEXT 640K
MAXDATAFILES 50
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
HTH,
Rajesh
-----Original Message-----
Sent: Wednesday, September 05, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Can someone tell me whats wrong with my script ?
CREATE DATABASE TEST
LOGFILE (
'/test/redo01.log' SIZE 10K,
'/test/redo02.log' SIZE 10K,
'/test/redo03.log' SIZE 10K
)
MAXL0GFILES 6
MAXINSTANCES 4
NOARCHIVELOG
CHARACTER SET US7ASCII
DATAFILE '/test/system01.dbf' SIZE 50M AUTOEXTEND ON
;
When I try this script, I recieve this
SVRMGRL> @CreateDB
'/test/redo01.rdo' SIZE 10K,
ORA-00907: missing right paranthesis
Thank You
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
