Re: Max File Size?

From: Don Seiler <don_at_seiler.us>
Date: Mon, 25 Aug 2014 13:47:29 -0500
Message-ID: <CAHJZqBCkxYc5ge5ppW37Jo_X2Ws3eVpxOCD=f4+pM7XA-_WmHQ_at_mail.gmail.com>

Joe, 32767 MB (or 1MB short of 32GB) is the max size (in MB, anyway) for a datafile that isn't defined as a bigfile.

Don.

On Mon, Aug 25, 2014 at 1:44 PM, Sweetser, Joe <JSweetser_at_icat.com> wrote:

> I am running 11.2.0.2 on RH 5 without any special settings/configs.
> Oracle seems to be pretty unhappy when an individual file gets over 32gb.
>
> alter database datafile '/u02/oradata/joedb/being_silly_01.dbf' resize
> 33056m
> ORA-1144 signalled during: alter database datafile '/u02/oradata/
> joedb/being_silly_01.dbf' resize 33056m...
>
> -joe
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Dave Morgan
> Sent: Monday, August 25, 2014 12:30 PM
> To: Oracle-L
> Subject: Max File Size?
>
> Hello All,
> In this age of arrays, SSD and virtual everything what are people
> using for a maximum data file size on their production systems?
>
> Since the 2GB physical disk limit is no longer with us :)
>
> TIA
> Dave
>
> --
> Dave Morgan
> Senior Consultant, 1001111 Alberta Limited dave.morgan_at_1001111.com
> 403 399 2442
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> Confidentiality Note: This message contains information that may be
> confidential and/or privileged. If you are not the intended recipient, you
> should not use, copy, disclose, distribute or take any action based on this
> message. If you have received this message in error, please advise the
> sender immediately by reply email and delete this message. Although ICAT,
> Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for
> viruses, it does not guarantee that either are virus-free and accepts no
> liability for any damage sustained as a result of viruses. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Don Seiler
http://www.seiler.us

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 25 2014 - 20:47:29 CEST