Oracle-L: RE: Oracle limitations?

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Fri, 25 Apr 2003 11:08:54 -0800
Message-ID: <F001.00589A57.20030425110854@fatcity.com>

Nope, no such size limitation defined (other than the overall database size which I don't think anyone has approached yet). Would you WANT to partition it is a different question. We had one client we tested a 20 TB (yes, I do mean terabyte) table on, and they had just over 5000 partitions defined for it IIRC.

The limitations are all listed in Chapter 4 of the Reference manual (at least for 9.2).

Pete
"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
Sent: Friday, April 25, 2003 9:32 AM
To: Multiple recipients of list ORACLE-L

Hi,

With Informix, if the size of a table is approaching to 32 GB, you have to fragment it to multiple dbspaces.

Does Oracle has similar limitation which you have to partition a table?

Can you fragment a table by round robin or expression?

Any other limitations that Oracle have?
(max size of tablespace, max number of datafiles within a tablespace, .. etc)

Thanks,

Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337

This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Roger Xu
INET: roger_xu_at_dp7uptx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Pete Sharman
INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------