Re: Adding new datafile question

ITAPORT06 <mokat67_at_hotmail.com> wrote :

> Orcale 8i on WINNT
>
>
> I have a tablespace with one datafile (1) which has almost grown to
> 2080MB. I read on the forum that it is better not going over 200OMB
> so I will add a 2nd datafile to this tablespace.

Huh? Who was the ass who said that?

There is, or was, a 2GB file limit on Unix. Maybe still is on some Unix flavours.

However, from an Oracle perspective is does not matter whether a datafile is 1GB or 3GB. If smaller files are better, then Oracle would have suggested a recommended practise of only creating small datafiles. Oracle does not.

> Datafile (1) has the following extend option: " autoextend on next
> 5120K"

I think auto extending datafiles are an evil. It removes control from *you* and gives it to a piece of software to do. I can never be comfortable not controlling how much space has been allocated to the database. Worse, auto extends make a damn poor crutch for space planning.

--
Billy