RE: Oracle9i data file size limitations on HPUX 11.11

Of course, you can have bigfile tablespace, containing a single moderatly large file, containing up to 4G blocks, up to 32kb long. This makes the largest supported file size equal to 128 TB. There is, however, a catch: you will have to upgrade to 10G to do that. Bigfile tablespaces are not supported in 9.2. If you do upgrade and use bigfile tablespaces, be aware that there are significant limitations with ROWID columns. Contrary to the popular belief, size does matter.
--

Mladen Gogala
Ext. 121

-----Original Message-----

From: Loughmiller, Greg [mailto:greg.loughmiller_at_cingular.com] Sent: Wednesday, December 08, 2004 9:18 AM To: 'oracle-l_at_freelists.org'
Subject: Oracle9i data file size limitations on HPUX 11.11

Hey guys,  

Quick question. We are working on an effort that will have a multiple Terabyte database. I am seeing conflicting information about the max size of a data file that Oracle will support. I see where a "vendor" indicates a 1.9TB data file in their proposal. But what I'm finding in the Oracle Doc is approx 127GB (32K block size). And the typical search of the web turns up yet a different answer.....  

So, I'm making the assumption of "4 million blocks max per data file" * the block size to derive the max oracle data file size (I'm not worried about the OS limitations at this time).  

Am I off track here? Making an incorrect assumption?  

Thanks!

Greg Loughmiller    

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 08 2004 - 08:46:37 CST