Re: db_files won't exceed 30 (but I need more)

Hi

You can try to increase the datafile size by entering the following command for the existing tablespaces, upto 2G I believe on UNIX:

alter database datafile '/u1/xyz/tablespace_01' resize 500M;

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

skubiszewski_at_Eisner.DECUS.Org wrote in article <EzHuvn.538_at_news.decus.org>...
> I'm running Oracle v7.2.3 on HP-UX v10.01. The database
> was created in 1996 using defaults (db_files=20) and
> db_files cannot be increased past 30. I'm getting
> concerned as we are currently at 21 datafiles and
> growing.
>
> I believe the only way to solve this problem is to
> create a new database but I thought I'd toss this
> out to the experienced DBAs out there. Is there
> any way to get our old, unsupported version of
> Oracle to accept db_files > 30?
>
> I've heard rumors there was...
>
> Thanks!
>
> Rose
>
Received on Mon Sep 21 1998 - 11:11:13 CDT