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

> 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)
>

It depends if you specify the tablespace to autoextend or not. So, by default, it will
not grow on their own.  

> 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?
>

The user will get an error message saying something about not being able to allocate an extent or something like that. However, you should monitor your
database to ensure that this does not happen. You can create some scripts that run nightly to let you know!

Good luck!

Brad Received on Tue Aug 12 1997 - 00:00:00 CDT