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.
From: Loughmiller, Greg
Sent: Wednesday, December 08, 2004 9:18 AM
Subject: Oracle9i data file size limitations on HPUX 11.11
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?