Re: Max # of datafiles??

No, bad luck. Only solution is recreating the database. You should try to give your files proper size, so that the number of files remains low. Probably it is advisably to do a full database export, and just destroy the complete instance and delete the files, otherwise recreating will fail because the size of the files changed.

Sybrand Bakker
Senior IS Analyst
Bentley Systems Europe
Sybrand.bakker_at_bentley.nl

MC12250 wrote:

> I have a production DB that was created with a max of 30 datafiles in the
> "CREATE DATABASE" statement. I know the parameter in the init.ora file
> can't override this. Is there an easy way to change this without re-creating
> the
> DB?
>
> Thanks,
> andy
> andy_at_mcdirect.com
>
Received on Thu Nov 13 1997 - 00:00:00 CST