Oracle 8i database creation assistant makes 175MB!!!! system tablespace datafile. Que?

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8i database creation assistant makes 175MB!!!! system tablespace datafile. Que?

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Tue, 16 Nov 1999 03:13:52 GMT
Message-ID: <3830caab.19289326@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 Mon Nov 15 1999 - 21:13:52 CST