Oracle Datafiles limit

How do you control No. of Datafiles one can have in an Oracle Database.

Questions by Pragati.rch

Showing Answers 1 - 6 of 6 Answers

olilogu

  • May 11th, 2009
 

At creation time you can set up the maximun numer of datafiles.
CREATE DATABASE .....
MAXDATAFILES  500
If you want to check it:
select * from V$CONTROLFILE_RECORD_SECTION where type ='DATAFILE';
If you want to increase it, you have to recreate control file.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions