Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Maximum number of partitions?

Re: Maximum number of partitions?

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 20 Jul 2004 17:34:16 +0300
Message-ID: <30e601c46e66$a3281890$0a879fd9@porgand>


> number of datafiles that Oracle can consist of. Since at least one =
> file
> would be needed for SYSTEM, UNDO, and TEMP there would only be 64K - 3 =
> files available for use.

Oracle Reference Guide states the maximum as 65533, depenent on underlying OS. I've had about 30000 datafiles in an experimental database and about 3000 in production ones.

Tanel.



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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 20 2004 - 09:30:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US