Re: Tablespace limitations
Date: 1995/07/18
Message-ID: <3uftuv$snj_at_epsilon.qmw.ac.uk>#1/1
In article <3u750v$9kd_at_Titania.wintermute.co.uk>, tawscomp_at_wintermute.co.uk (Stephen Taws) writes:
>mtackett_at_dayton.csc.com (Michael Tackett) 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
>
>I Think your problem is that you have created a database with a
>maximum database files default of 30 files. This means that your
>database cannot grow any further.
>
>To fix your problem, create a new,copy database with the maxdatafiles
>set to a large value, say 121. examine how big your database is at
>present in order to size the creation your tablespace datafiles.
>Use export to copy your data.
>
>NB. Make sure you know the defaults when you create a database, some
>of them are a lot lower than you imagine.
>
>Steve Taws
>
I have also come accross this problem on a Dec Vax Vms & Dec Osf/1
The databases in both cases were so large that we could not import the entire contents to disk and reimport.
The way we got round this was as follows.
1 ) backup the entire database (offline)
2) alter database backup controlfile to trace;
3) edit the trace file that was produced in 2 to change maxdatafiles to 64
4) drop controlfiles
5) run trace file to recreate control files
6) backup the database again.
You have to have no users around while you do all of this.
We had no problems after this and was able to add extra datafiles.
Please check with Oracle if this is supported else on your own head be it.
J L Budnarowski email jared1_at_middlesex.ac.uk
Middlesex University
North London
England Received on Tue Jul 18 1995 - 00:00:00 CEST