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

In article <31652035.59618968_at_news.brookings.net>, kasten_at_brookings.net says...
>
>duffy_at_www.co.mo.md.us wrote:
>
>> Oracle installation guide mention the data file size between 300 to 500 MB.
 

>> Can anyone tell me why Oracle has this limitation? My data file eventually
>> will grow up to 20 GB. Does their has a way to around it? For 20GB
>> data file, how to do cold backup. Thank you.
>

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...

You should be ok because an Oracle tablespace can be made up of multiple data files. You could have a tablespace that consists of (10) 2GB data files.

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 |  --  //
    `-' `-------------------------------------------------------'      ~