Re: Tablespace limitations

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

: Thanks,
: Mike Tackettt

Try using the line

db_files = <something bigger than 30>

in the .ini file for your instance.

--
Chris Selwyn
Senior Consultant
Perihelion Software
email: chris_at_perihelion.co.uk tel: +44 1749 344203