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

If you're aiming to use Designer 2000 you may need up to 200MB system tablespace!! Stick with the 175 - you can always resize it later

Alex

On Tue, 16 Nov 1999 03:13:52 GMT,
granta_at_nospam.student.canberra.edu.au (Fuzzy) wrote:

>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 - 05:40:19 CST