Re: HOW to increase DB_FILES?

DLEUNG wrote:
>
> HI ,
>
> I am trying to increase the Max.number for DB_FILES in
> oracle 7.32. (solaris platform),
> because I would like to add more files to a tablespace.
>
> BUt I got the following error:
> alter tablespace data05 add datafile '/u9/oradata/CNC01/data05_u9.dbf' size 150M
> *
> ERROR at line 1:
> ORA-00059: maximum number of DB_FILES exceeded
>
> -----
> I go to init_instance_name.ora
> and change the db_files from 20 to 40 ,
> and then shutdown oracle and bring up by
> startup.
> BUt it still say the same error.
>
> I call Oracle support,
> they told me instruction of recreate control_files
> to increase MAXDATFILES,
> I can successfully increase the MAXDATAFILES to 60, but it does not
> help me ,
> I try to add one additional (new ) file to a tablespace data05
> , I havethe exact error again.
>
> I really appreciate if anyone can give me some help/hint,
> because ORacle Support is very unhelpful.
> They told me , it should work.
> I am wondering whether MAXDATAFILES has anything to do with DB_FILES?
>
> Please email me directly, because I dont read this news group that often
>
> Thank you in advance,
>
> Dominica Leung
>
> dleung_at_cncx.com
>
> or dleung_at_concentric.net

Cant identify the error, but maybe you can use: ALTER DATABASE DATAFILE 'file' RESIZE size;

Good luck Norbert

-- 
=====================================
Norbert Ferstl
DI Forsthuber GmbH
Kohlbauernstr. 17
A-2630 Ternitz, AUSTRIA
Tel: +43 2630 382500
Fax: +43 2630 3825014
<ferstl_at_netway.at>
=====================================