Re: Tablespace limitations

In <DB1wnr.KBF_at_cs.dal.ca> ae873_at_ccn.cs.dal.ca (Murray Kaiser) writes:
>
>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
>
>My guess is that the maxdatafiles was set at 30 when the database was
>created. If this is true and you need to add more datafiles, you will
>have to do a full database export, recreate the database with a larger
>maxdatafiles and then do a full database import.

Why can't he simply shutdown the instance, increase the maxdatafiles parameter in the parameters file (I forget the exact name - something.ora) and restart the database?

I ran into this same problem on a Netware installation and that's all I had to do. This was Oracle7 version 7.1.3.

-- 


><>    Chuck Hamilton    <><

><> chuckh_at_ix.netcom.com <><