Re: Oracle7 Datafile creation problem - help!

It sounds like you have reached/exceeded the MAXDATAFILES parameter that was specified during the initial DB build. Check your DB_FILES parameter in your init<SID>.ora file and compare it to select count(*) from dba_data_files. If this is the case, I have a white paper from Oracle explaining how to correct this. Basically, you need to:

alter database backup controlfile to trace; rename the trace file (ie recreate.sql) edit recreate.sql and delete trace header info, and increase maxdatafiles shutdown the database NORMAL or IMMEDIATE (not ABORT) and take a full backup remove existing control files
from sqldba, connect internal, then run @recreate alter database open noresetlogs;

You should receive a "Statement processed" message, indicating your database is back up and running with the higher maxdatafiles limit. You should now shut down and take another full backup.

In article <36DAD344.463D0F1A_at_basford.demon.co.uk>,   ed <ed_at_basford.demon.co.uk> wrote:
> I've just attempted to create a datafile on Oracle 7.1 and AIX 3.2.5. I
> got an error message saying something like "DB FILES exceeded". It
> created the file, but Oracle can't see it or use it. Can anybody help?
> Ideally, I'd like to get rid of this file and create a new one, but I'd
> be happy to get this working and then add another datafile? Anybody
> help?
>
> Thanks.
>
> Ed.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 09:10:58 CST