Can't add datafile to a table space

[YM]

I was getting an error when adding datafile to a tablespace. The message indicates that it reaches the max datafiles allowed for this tablespace. What can I do?

Urgent!

Thanks,

YM

[marist89]

What's the error message & Number?

It might be as easy as checking the init.ora parameter db_files and increasing it.

[vendechukp]

check the db_files parameter .

If it is less then increase the number.

shutdown the database and restart the database.

u are done

[SANJAY_G]

If it is not due to db_files limitation in init.ora then it may be bacause of the maxdatafiles limit in control file.

HTH
Sanjay

[sandycrab]

Dear Sanjay, Give a solution brother for this...how can you change that in control file??
See at the time of database creation you might have given low MAXDATAFILES value.
Change your init.ora parameter(db_files). It will work...
Sandy

[pando]

Originally posted by sandycrab
Dear Sanjay, Give a solution brother for this...how can you change that in control file??
See at the time of database creation you might have given low MAXDATAFILES value.
Change your init.ora parameter(db_files). It will work...
Sandy

it will work in 8i but in 7/8 you have to recreate control files

[SANJAY_G]

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Edit the script generated in udump directory.

Recreate controlfile.

HTH

Sanjay

[julian]

Often upon DB creation, MAXDATAFILES is left to its default value which is OS-specific, for UNIX it is often 30, for NT it is 254 for Oracle 8 and 8i, for VMS there is no limit in 8i as far as I remember. Often left with the default value of 30 for UNIX, the DBA comes to a point when he has to recreate the CF. I guess this is your case, right?

[YM]

Thank you all so much. I didn't realize that I got the support back so fast. I was wondering why it was taking so long. This is my first time. I think my e-mail notification function was not set up right in my profile.

Again, thank you very much.

ym