Originally posted by pipo
anyway, 99.99% of the databases won't even reach 100 datafiles, so 1022 or 1023 is far from being a reachable limit, except if you have 2Tb of data ... in one tablespace, which indicates that there is a slight problem of conception in the architecture ...

[Edited by pipo on 10-02-2001 at 07:39 AM]
If your MAXDATAFILES has the UNIX default of 30, how can (s)he make 31 datafiles in his INDEX tablespace? Only if (s)he recreates the control file first :-)