Tablespace limitations

From: Ralf Karpa <rkarpa_at_northcup.eurostar.de>
Date: 1995/07/02
Message-ID: <92b_9507022335_at_ftn.eurostar.de>#1/1

Hi mtackett_at_dayton.csc.com!

Reply to a message from mtackett_at_dayton.csc.com to All:

 m> I am running ORACLE7 on a HP-UX machine.  I am relatively new to ORACLE
 m> DBA administration.  I am getting an error ORA-01118: cannot add any
 m> more database files: limit of 30 exceeded.  Does anyone know what
 m> might be causing this problem?

I think, that you have set the parameter "maxdatafiles" in the "CREATE DATABASE" command to this value. This means, that you not have more than 30 datafiles. From this point, there is no way to extend this, without creating a new database, because ORACLE reserves this number of slots in the control-files of the database. But they forgot to have a utility, which lets you extend the number of slots.

Bye Ralf! Received on Sun Jul 02 1995 - 00:00:00 CEST