Re: Do datafiles on my Disk Drive grow on thier own?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/07/25
Message-ID: <33d91440.28089750@newshost>#1/1

On 25 Jul 1997 19:49:20 GMT, satarnag_at_aol.com (SatarNag) wrote:

>Disk Drive ---> Datafile ----> Tables
>
>We are using Oracle 7.3, and a couple of our datafiles are almost full,
>
>1. Will My datafiles grow on thier own? ( I say no, but I'm not sure)
>

If your compatible parameter (found in the init.ora) is set to 7.2 or up AND you have issued:

alter database datafile 'filenamehere' autoextend on NEXT [size]

then yes, your datafiles will grow as needed. This is typically only useful with cooked file systems (regular UFS or NTFS files). You can bound their growth (give a max size) and even shrink them if you want (resize).

>2. When my datafile does get full, what happens when someone adds data to
>a Table that is in that DataFile? Would they get an error? How will Oracle
>Respond?

They will get an error back. Their statement will fail.

>
>Please Help me by sending me E-mail at SatarNag_at_aol.com
>I thank you in advance for any help.
>Satar Naghshineh

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jul 25 1997 - 00:00:00 CDT