Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: max size of datafile
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