Re: Initial Size of Oracle Database

Frank,

Thanks for your response. I'll give it a try!

Al

"frank.sara" <frank.sara_at_infonie.fr> wrote in message news:987536682.685833_at_remus.infonie.fr...
> First of all, do not use the default database. Create a new one with
> dbassist. After that, don't select any options ( Java server, sql help,
> replication etc) went prompt in dbassist. Once you get to the tablespace
> size tabs, system can be very small, go for 10 meg with autoextend on, 2
> megs with temporary. As for tools and user, if you dont use them, you can
> make them 500K in size and you wont have any problem. The rollback
> tablespace can be set to 5 megs if you use 5 rollback segment of 1 meg
 each.
> anyway just leave anything with autoextend on.
>
> good luck!
> Al Willis <alwillis_at_pdq.net> a écrit dans le message :
> D36111974A3E36F2.21D378F14E9E923A.68360D0226E5A2B3_at_lp.airnews.net...
> > I'm very new to Oracle. Can someone please provide me with specific
> > information on how to minimize the initial size of an Oracle database.
 When
> > I create a database using the standard tools, it comes out to about 250
 MB
> > in size. This is in comparison of a typical empty MS SQL Server
 database
> > size of 2.1 MB. My databases are typically relatively small. The
 largest
> > table would typically have about 25,000 records of about 1200 bytes per
> > record. There may be 400 tables in the database, most of them much
 smaller
> > than the example that I have given. The platform is Windows NT/2000.
> >
> > Multiple Oracle databases the size of 250 MB would quickly swamp my
 clients
> > storage capabilities.
> >
> > Any help is appreciated.
> >
> > Thanks,
> >
> > Al Willis
> >
> >
>
>
Received on Tue Apr 17 2001 - 20:41:34 CDT