Re: File limit reached

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 4 Sep 1999 11:30:26 +0200
Message-ID: <936437472.24940.0.pluto.d4ee154e@news.demon.nl>

There also is a maxdatafiles setting at creation of the database. Apparently db_files should be <= maxdatafiles and you have reached the maxdatafiles limit.
If you have 7.3 or higher you could resize one of your files with alter database datafile <> resize <>.
Otherwise... yes, recreate the database.

Hth,

--
Sybrand Bakker, Oracle DBA

<nightwalker_ru_at_my-deja.com> wrote in message news:7qqn91$tl1$1_at_nnrp1.deja.com...
> Hi!
>
> Recently I encountered strange problem.
> Whenever I try to add datafile to any
> tablespace, I get error:
>
> ORA-01118 cannot add any more datafiles:
> limit of 30 exceeded
>
> In my init<SID>.ora file there is parameter
> db_files = 64
> so I thought that limit is 64 files. Or I am
> wrong?
>
> Any advice is welcome. Thanks.
>
> Nightwalker
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sat Sep 04 1999 - 04:30:26 CDT