Re: Tablespace limitations

There are two issues here the original posting, as someone correctly identified, has hit the maxdatafiles limit which is held in the control file and thus cannot be directly altered. This is diffrent from the init.ora paramter of DB_FILES. If DB_FILES had been exceeded then he more likely would have got ORA-59.

There are three ways to deal with the ORA-01118 problem :-

1. Reduce the number of data files associated in the largest (in terms of datafiles) tablespace. Export all objects from the tablespace, drop, re-create it and re-import.
2. You could, as was also suggested, re-create the database with a bigger maxdatafiles. (A bit extreme if this a large production database!)
3. Re-create the control file with a larger maxdatafile value. (This is supported by Oracle from 6.0.33.1 and onwards - which would be my favourite)

Regards,

Tony Poulson
Database Administrator
European Bank for Reconstruction and Development Received on Mon Jul 03 1995 - 00:00:00 CEST