Re: question on limits

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/03/09
Message-ID: <5ftinl$lnr@mtinsc04.worldnet.att.net>#1/1

There is no limit on the number of datafiles belonging to a tablespace per se, but there is a limit on the number of datafiles that make up an ORACLE database. I believe that for UNIX the limit is 1022 datafiles. You can control how many datafiles your database can have with the MAXDATAFILES clause in the CREATE DATABASE.... statement (default=30) and the DB_FILES parameter in INIT.ORA file (DB_FILES<=MAXDATAFILES<=1022).

You can change DB_FILES at any time by editing the INIT.ORA, shutting down and re-starting the instance; to change the MAXDATAFILES value, you have to use the CREATE CONTROLFILE statement (be careful with this one !).

I hope this helps.

Michael Serbanescu
Senior Consultant, MIACO Corporation.

---

Hari Duthaluru <hari_at_leis.bellcore.com> wrote:
>Is there any limitation on the number of datafiles that a tablespace
>can have on UNIX?
>
>
>thanks,
>hari
Received on Sun Mar 09 1997 - 00:00:00 CST