Wednesday, May 30, 2018

ORA-03206: maximum file size of (6553600) blocks in AUTOEXTEND clause is out of range

I received below error while extending the datafile. You might see below error when creating tables space too.

SQL> alter database datafile '/oradata1/ORCL/orcl101.dbf' autoextend ON maxsize 50g;
alter database datafile '/oradata1/ORCL/orcl101.dbf' autoextend ON maxsize 50g;
*
ERROR at line 1:
ORA-03206: maximum file size of (6553600) blocks in AUTOEXTEND clause is out of range


The reason is maximum file size for an autoenxtendable file has exceeded the maximum number of blocks allowed. Note that Oracle allows only up to 32GB datafile with 8k blocks. If you want to create a tablespace or datafile more than 32GB then you must use BIGFILE keyword.

To calicuate max datafile size:
max datafile size = db_block_size * maximum number of blocks

Solution: create a file less than 32 GB size or if you need to create datafile more than 32GB then use BIGFILE keyword.

SQL> alter database datafile '/oradata1/ORCL/orcl101.dbf' autoextend ON maxsize 32767M ;
Tablespace altered.

Hope this helps,

Regards
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com

29 comments:

  1. hmm, https://tanvirhossain.com.bd

    ReplyDelete
  2. This is a savvy blog. I would not joke about this. You have such a great amount of learning about this issue, thus much energy. You additionally know how to make individuals rally behind it, clearly from the reactions.
    memory of Tatooine
    The set jogs my
    wows netizens
    TV rankings
    agani" scores
    darkish coloured pores and skin
    ABagani March
    Four Oras June 6

    ReplyDelete
  3. Packers and Movers Bangalore 100% Affordable Local Household Shifting Services. Compare Relocation Charges, Get Free Best Price Quotes: Verified and Trusted Packers and Movers in Bangalore, Cheap and Safe Local, Domestic House Shifting @
    Packers And Movers In Bangalore Local

    ReplyDelete
  4. Your blog is great. I read a lot of interesting things from it. Thank you very much for sharing. Hope you will update more news in the future.
    - USPS Tracking

    ReplyDelete
  5. Packers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔✔✔Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @
    Packers And Movers Chennai

    ReplyDelete
  6. You did really good work. I really appreciate your new and different post. Please guys keep it up and share with us some unique post in the futureMenmyshopCar StereoDouble Din Android PlayerHyepersonic Double Din PlayerHyundai Creta Double Din Player
    CBSE open schoolcbse privatebanzaraonjourneyAdj online

    ReplyDelete
  7. hello sir,
    thanks for giving that type of information.
    website designing company

    ReplyDelete
  8. nice topic which you have choose.
    second is, the information which you have provided is better then other blog.
    so nice work keep it up. And thanks for sharing.Digital PVC Door suppliers in Karnataka

    ReplyDelete
  9. Thanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge. Tourist visa provider in Delhi

    ReplyDelete
  10. Hire Manish Packers and Movers Pvt Ltd in India for hassle-free Household Shifting, Office Relocation, Car Transporation, Loading Unloading, packing Unpacking at affordable Price Quotation. Top Rated Safe and Secure Service Providers who can help you with 24x7 and make sure a Untroubled Relocation Services at Cheapest/Lowest Rate. Visit More :-
    Manish Packers and Movers Pvt Ltd
    Packers and Movers Bangalore
    Packers and Movers Gurgaon
    Packers and Movers Indore
    Packers and Movers Kolkata
    Packers and Movers Mumbai
    Packers and Movers Nagpur
    Packers and Movers Ahmedabad
    Manish Packers in Indore
    Manish Packers and Movers Pvt Ltd Sitemap

    ReplyDelete
  11. Manish Packers and Movers Pvt Ltd as a Services providing company can make all the difference to your Home Relocation experience. Indore based Company which offers versatile solutions, Right team that easily reduce the stress associated with a Household Shifting, Vehicle Transportation. we help things run smoothly and reduce breakages and offer you seamless, Affordable, Reliable Shifting Services, Compare Shifting Charges, Visit : https://www.manishpackersmoversindore.in/
    https://www.manishpackersmoversindore.in/
    https://www.manishpackersmoversindore.in/packers-and-movers-indore.html
    https://www.manishpackersmoversindore.in/manish-packers-and-movers-indore.html
    https://www.manishpackersmoversindore.in/packers-movers-gurgaon.html
    https://www.manishpackersmoversindore.in/packers-movers-kolkata.html
    https://www.manishpackersmoversindore.in/packers-movers-mumbai.html
    https://www.manishpackersmoversindore.in/packers-movers-bhopal.html
    https://www.manishpackersmoversindore.in/packers-movers-nagpur.html
    https://www.manishpackersmoversindore.in/packers-movers-raipur.html
    https://www.manishpackersmoversindore.in/packers-movers-ahmedabad.html

    ReplyDelete
  12. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.


    python training in pune

    ReplyDelete
  13. Packers and Movers Gurgaon Provide Reliable, Safe and Certified Service Provider list, Get Free ***Best Price Quotaition and Compare Charges. ✔✔✔ Hassle free Household Shifting Services, High Quality packing Material, Office Relocation, Car Transportaion, ###Local and Domestic Shifting Service @
    Packers And Movers Gurgaon

    ReplyDelete
  14. Subway Princess Run 2018 - Angry Running Princess
    Amazing. You are doing very brillient work and i always follow you. Best of Luck
    From Team Subway Princess Run

    ReplyDelete
  15. AGT The Champions: I’m really happy to say it was an interesting post to read. I learned new information from your article, you are doing a great job. Continue -> AGT The Champions Winner

    ReplyDelete