Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db_files won't exceed 30 (but I need more)
This will work ONLY if the parameter DB_FILES is SMALLER than the parameter
of the Maxdatafile when you first create the database!!! If the MAXDATAFILE
is 100 when you first create your database and you set the DB_FILES as
anything less than 100. Then you can always edit the init.ora parameter to
increase the number of DB_FILES. But if it pass the 100 limit, the only way
that you can increase the number of DB_files is to recreate the controlfile!
Winnie
Barry Lau wrote in message <6u2urc$t1m$1_at_imsp009a.netvigator.com>...
>That shouldn't be to hard. Just edit your init.ora and put in DB_FILES =
>64, then you have 32 more files to play with.
>
>We did that every 12 to 18 months.
>
>Regards, Barry
>
>
>
Received on Mon Sep 21 1998 - 00:15:50 CDT