Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafile autoextend w/o maxsize
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 worseReceived on Mon Jul 03 2000 - 00:00:00 CDT