RE: Create Database ORA-907 need help

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 05 Sep 2001 01:05:45 -0700
Message-ID: <F001.00382D2C.20010905010053@fatcity.com>

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: sinardyxing_at_bcsis.com

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: ListGuru_at_fatcity.com (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: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------