RE: Creating DB on partition > 2TB

From: D'Hooge Freek <>
Date: Fri, 7 Mar 2008 08:10:43 +0100
Message-ID: <>

Can't you just hit ignore?
I remember having used a database on a 2.7 TB partition (test setup) and I know I have seen this problem, but I don't remember creating the database by hand...


Freek D'Hooge
Oracle Database Administrator
tel. +32 (0)3 451 23 82

From: [] On Behalf Of William Wagman [] Sent: 06 March 2008 22:30
Subject: Creating DB on partition > 2TB


I have installed Oracle on a server running Centos 4, 2.6.9-67.0.4.Elsmp. This is a new server and installation. I am using the DBCA to create the database which initially will only be 2GB. The partition on which I am attempting to create the database has nearly 3TB of space and when I attempt to create the database dialogue box is presented with the message...

You do not have enough free space
You need 1845248KB
You have -1570091008KB

Oracle is telling me that the DBCA is unable to properly compute space on a partition > 2TB and suggests either creating the database manually, the scripts were created, or dividing the disk into partitions < 2TB. I haven't yet tried to create the database manually as I am concerned about whether or not if the DBCA gets confused with such a large partition that Oracle will also get confused.

So, I'm looking for suggestions or experiences with similar situations.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208
-- Received on Fri Mar 07 2008 - 01:10:43 CST

Original text of this message