Re: [Q] Why Oracle data file can nor > 500 MB ?

sbourgeo_at_ici.net (Steve Bourgeois) wrote: << SNIP original question re: Oracle's recommended file size limit. >>

>
>With version 7.2, Oracle data files can be a maximum of 4GB. This
>has increased to 14GB with version 7.3.
>
>However, on most UNIX implementations the largest file size you can
>have is 2GB. Digital UNIX is the only flavor that I know of that will
>allow you to create files > 2GB. If your database is on raw devices,
>then this will not be a problem...
>
 

>
>Steve
>
>--
> ,_______________________________________________________,
>~~~ ??| |
>c-OO | Steve Bourgeois
> ) / | Oracle Corporation
> - | Boston, MA | /__ OO-
>==() | | | |o U
> || _| sbourgeo_at_us.oracle.com, sbourgeo_at_ici.net | | |== )=
> \\_//| http://www.ici.net/cust_pages/sbourgeo/sbourgeo.html | -- //
> `-' `-------------------------------------------------------' ~
>

Also make sure your ulimit is set high enough to handle the size of the files you are creating.

-- 
Mike Morgan
Technology Integration Services - Unix DBA
-----------------------------------------------------|
email: mike.morgan_at_teldta.com | Phone: (608)845-4661 |
-----------------------------------------------------|
TDS Computing Services                               |
301 S. Westfield Road                                |
Madison, WI 53705  USA                               |
-----------------------------------------------------|