Re: datafile autoextend w/o maxsize

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/03
Message-ID: <3960775C.6F50@yahoo.com>#1/1

sfcheng_at_my-deja.com wrote:
>
> I found the following question on a website, but couldn't find the
> solution.
> Could anyone answer it? Thanks a bunch.
>
> When created a tablespace, set AUTOEXTEND ON with no MAXSIZE.
> What could cause the corresponding datafile to reach maximum # of bytes?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

tablespaces do not have autoextend - data files do...with no maxsize set you will either run out of disk or reach an operating system limit on the size of a file (or a specified limit on the userid)

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Mon Jul 03 2000 - 00:00:00 CDT