Re: System table space size in Oracle 8.0.5

Rob,

Which version are you upgrading/migrating from? Each new release of Oracle seems to require more system tablespace space than the previous versions. This is due to the change in the data dictionary requirements to support new features.

To give you an idea, one of my Oracle 8.0.5 instance is using about 40 MBytes of system tablespace size. This will vary from database to database depending on how big your data dictionary gets. For instance, lots of stored procedures and packages require space in SYS.SOURCE$ and therefore require more system tablespace space.

The Oracle installation and/or migration guides should give you an idea of what Oracle recommends.

HTH,
Brian

Rob Feehan wrote:
>
> Can anyone tell me the size that the system table space needs to be in
> 8.0.5? It seems to need a bigger initial size than previous versions.
>
> Thanks
>
> Email replies appreciated.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================