Guest_imported
New member
- Jan 1, 1970
- 0
Please let me know maximum no datafiles will be allowed in Oracle 8 incase of 8K block size.I shall appreciate your answer.<br><br>satish
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
No of maxdatafiles in Oracle 8.x for 8K block size
- Thread starter Guest_imported
- Start date
- Status
Hi Satish,<br><br>Maybe I'm completely wrong here (it has been known) but I thought the block size had more to do with the number of extents you're allowed in an object (and even that goes away > 7.3) rather than the maximum num of data-files, *that's* configurable in your init.ora file for that DB.<br><br>Someone jump in and correct me if I'm wrong please.<br><br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href= Cargill's Corporate Web Site</a><br>
Hi Satish<br><br>As Mike told block size noway concern with No of datafiles.<br>Maximum no of datafiles depends on your OS. Whenever you create database you have to mention the Maximum datafiles in your control file. In WinNT it allows 1024 files.You Init.ora parameter shouldn't exceed more than control parameter. If you want to increase more than control specified then you have to re-create the control file.<br><br><br>S.Kirubakaran<br><A HREF="mailto:Kirubakaran_s@lta.gov.sg">Kirubakaran_s@lta.gov.sg</A>
- Status
