Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: datafile autoextend w/o maxsize

Re: datafile autoextend w/o maxsize

From: <yong321_at_yahoo.com>
Date: 2000/07/03
Message-ID: <8jr3rr$891$1@nnrp1.deja.com>#1/1

In article <8jooil$inr$1_at_nnrp1.deja.com>,   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.
>

Not sure about the question. Is it asking whether there's a default max file size for datafiles? If so, yes. It's 2GB (4GB maybe for newer versions).

--
Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Jul 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US