!! Please do not post Off Topic to this List !!
Christopher R. Spence said:
You can only have a max of 8 log groups if I remember correctly.
Gee, I thought that the DBA controlled the maximum number of redo logs
allowed for a database.
There's this thing called a database create statement: (e.g.)
CREATE DATABASE DEV
LOGFILE 'E:\Oracle\oradata\DEV\redo01.log' SIZE 16384K,
'E:\Oracle\oradata\DEV\redo02.log' SIZE 16384K,
'E:\Oracle\oradata\DEV\redo03.log' SIZE 16384K,
'E:\Oracle\oradata\DEV\redo04.log' SIZE 16384K
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'F:\Oracle\oradata\EMS\system01.dbf' SIZE 320M REUSE AUTOEXTEND ON
NEXT 32768K
MAXDATAFILES 128
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
Funny, how reading the documentation or just looking at your create scripts
can answer lots of questions before just simply spewing email. Personally, I
try to send fewer, higher quality emails rather than dozens of things that
are the first thing that pops into my head.
Paul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
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).
