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: max size of datafile

Re: max size of datafile

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 08 May 2001 21:40:55 +0800
Message-ID: <3AF7F767.2371@yahoo.com>

andy wrote:
>
> I have an Oracle 7.3.4 database under Sco Unix Openserver 3.2 5.0. The
> db_block_size parameter is set to 2048.
> What is the maximum size reachable of one datafile?
>
> Thanks in advance.
>
> Andy.

Many different limits apply - my personal opinion that any datafile over 2g starts to be a problem due to any of:

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"
Received on Tue May 08 2001 - 08:40:55 CDT

Original text of this message

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