Re: Oracle9i data file size limitations on HPUX 11.11

How long does it take to restore a a 128 TB file?

1. 42 minutes
2. 42 hours
3. 42 days
4. 42 months
5. 42 years f ) 42 lifetimes
6. all of the above

Jared

On Wed, 8 Dec 2004 09:45:59 -0500, Gogala, Mladen <MGogala_at_allegientsystems.com> wrote:
> 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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l