Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i database creation assistant makes 175MB!!!! system tablespace datafile. Que?
Hi,
my suggestion is, create the 175MB file, or at least 100MB. Our RDBMS (for
developing) uses 75MB after creation of some DBs, users,...
But I think your Redo Log-Files are too small, 500k is good for demo DB...
Christoph
Fuzzy schrieb in Nachricht <3830caab.19289326_at_newshost.interact.net.au>...
>Here's the deal
>
>Oracle 8i on RH6.0. Run the nice GUI database creation assistant
>thing, and it takes all you suggested values, BUT, it decides to use
>the following create db command
>
>CREATE DATABASE "GLX1"
> maxdatafiles 254
> maxinstances 8
> maxlogfiles 32
> character set US7ASCII
> national character set US7ASCII
>DATAFILE '/usr/oracle/database/8.1.5/oradata/GLX1/system01.dbf' SIZE
>175M
>logfile '/usr/oracle/database/8.1.5/oradata/GLX1/redo01.log' SIZE
>500K,
> '/usr/oracle/database/8.1.5/oradata/GLX1/redo02.log' SIZE 500K;
>
>
>My problem is the system datafile ... 175MB!!!! What the hell is
>this for. Luckily I scripted this, rather than letting the GUI do it,
>so I can change the value. Please tell me it's OK to use something
>more reasonable like 50MB? I can't believe 8i needs this much room
>for the data dict. tables.
>
>Ciao
>Fuzzy
>:-)
>
Received on Tue Nov 16 1999 - 03:28:01 CST