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