Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: unable to create data dictionary views

Re: unable to create data dictionary views

From: Stefan Moeding <s.moeding_at_ndh.net>
Date: 2000/05/19
Message-ID: <87n1lmif7h.fsf@esprit.sfx.ddns.org>#1/1

Hi!
Peter Schupp writes:

> I create my database this way:
> create database VIS1
> logfile group 1 ('oit1log11.log', 'oit1log12.log') size
> 50K,
> group 2 ('oit1log21.log', 'oit1log22.log') size
> 50K
> datafile 'oit1_00.dbf' size
> 10M
> maxlogfiles 5
> maxloghistory 100
> maxdatafiles 10
> maxinstances 2
> archivelog
> ;

Your problem seems to be the size! I have never installed 8.0 but I couldn't get 7.3 up with less than 20M system tablespace. You should probably use more (maybe 50M). And the redo logs are much too small as well. I would use 2M at least and make them even bigger depending on the workload.

HTH

-- 
Stefan
Received on Fri May 19 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US