Re: Tablespace limitations
Date: 1995/07/06
Message-ID: <3tfg2p$l77_at_abyss.West.Sun.COM>#1/1
In article dv3_at_bell.ukonline.co.uk, chris_at_perihelion.co.uk (Chris Selwyn) 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
>
>Try using the line
>
>db_files = <something bigger than 30>
>
This will not help as U'r database would have been built with the default
value of 30 for maxdatafiles.
U have to shutdown U'r database, save control files ( better rename them ) and
then do a create control file after U startup with no mount option .
Please look into the guides for CREATE CONTROLFILE syntax.
U have to set maxdatafiles in U'r statement for a value say 40 or 50 or 100
and this increases U'r controlfile's sizes - So U cannot Use reuse option.
All the best.
SRIRAM
>in the .ini file for your instance.
>
>--
>Chris Selwyn
>Senior Consultant
>Perihelion Software
>email: chris_at_perihelion.co.uk tel: +44 1749 344203
Received on Thu Jul 06 1995 - 00:00:00 CEST