!! Please do not post Off Topic to this List !!
I forgot the word default; I know 8 used to be the default. I tend to be
doing many different things when I respond to emails. I guess it would be
much easier if I didn't post at all. Not like I ever ask questions on the
list.
But thanks for your flame, specially the one you sent privately stating you
wish me to get kicked off the list the other day. Keep up the good work.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Friday, September 14, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
!! 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
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).
