The problem you've got is one of two things
- init.ora parameter max_datafiles is set to 32, in which case just
increase it.
- Your database was created with max number of datafiles set to 32. If
this is the case you cannot so easily change it as it is fixed for the
database at creation time.
The only way I know of changing this parameter is to do the following;
- sqldba alter database backup controlfile to trace. this will give you
a file containing your database create statement.
- alter the db_files parameter to a large number eg 1000.
- shutdown the database.
- from within sqldba run the amended script from step 1. This in effect
recreates the control file with the amended parameter.
Hope this helps,
Let me know if you need more info.
Regards,
Phil
Received on Fri Aug 08 1997 - 00:00:00 CDT
