Re: Initial Size of Oracle Database

Why not create multiple schemas within a single oracle instance so that each of your sql server databases is created under an oracle user. That way you will be able to add new schemas very easily and it will be much more efficient for oracle in terms of memory and processes.

Alan

"Al Willis" <alwillis_at_pdq.net> wrote in message news: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 - 07:19:38 CDT