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

16 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. 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
  4. 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
  5. 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
  6. 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
  7. Nice blog to read, Thanks for sharing this valuable article.

    Data Science Training In Bangalore

    ReplyDelete
  8. Punjab School Education Board is Going to Punjab Board 5th Class Exam Start in Tuesday, 18 February 2023 End of Exam Wednesday, 26 February 2023 and Punjab Board 8th class Exam Start in Tuesday, 3 March 2023 End of Exam Saturday, 14 March 2023, Punjab School Education Board is a School board based in Chandigarh, India. It was founded in 1969 under a legislative act of the Government of Punjab. PSEB 6th Class Model Test Paper 2023 PSEB 6th class Question Paper 2023 has been Uploaded here for Candidates who are in 6th class of Punjab Board Preparing well for SA, FA Examination 2023, Punjab Education Board Releases the Punjab 6th Question Papers 2023 Every year.

    ReplyDelete
  9. عيادة أحمد عبد السلام هي واحدة من أفضل مراكز تكميم المعدة في مصر يقدم مجموعة شاملة من الخدمات ويضمن فريقه من المهنيين الطبيين ذوي الخبرة أن يتلقى كل مريض أعلى جودة ممكنة من الرعاية.

    ReplyDelete