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
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
ReplyDeleteHollywood Songs Lyrics
hmm, https://tanvirhossain.com.bd
ReplyDeleteTanvir Hossain
ReplyDeleteThis 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.
ReplyDeletememory of Tatooine
The set jogs my
wows netizens
TV rankings
agani" scores
darkish coloured pores and skin
ABagani March
Four Oras June 6
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 @
ReplyDeletePackers And Movers In Bangalore Local
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.
ReplyDelete- USPS Tracking
Excellent blog. Very informative.Keep it up!
ReplyDeleteBest Selenium Training Institute In Hyderabad | Online Selenium Training
Great information. It was very helpful for me. Keep it up!
ReplyDeleteBest Data Science Online Training Institute In Hyderabad
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
ReplyDeleteCBSE open schoolcbse privatebanzaraonjourneyAdj online
hello sir,
ReplyDeletethanks for giving that type of information.
website designing company
nice topic which you have choose.
ReplyDeletesecond 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
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
ReplyDeleteI believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
ReplyDeletepython training in pune
tu cheez lajawab
ReplyDeleteLyrics with music
ReplyDeleteEnglish Song lyrics
Subway Princess Run 2018 - Angry Running Princess
ReplyDeleteAmazing. You are doing very brillient work and i always follow you. Best of Luck
From Team Subway Princess Run
Prospectus Patrachar Vidyalaya
ReplyDeleteCBSE Forms
CBSE Patrachar Delhi
Patrachar Vidyalaya phone no.
English Song lyrics
ReplyDeleterefrigerator repair in gurgaon
ReplyDeletesurveillancekart security system
ReplyDeletesurveillancekart cctv installation services
cp plus
Pestveda pest control services
Pestveda termite control service
dezigly
The feedgasm Latest News And Breaking News
quicksodes
latest news in hindi
thesportsrumour
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
ReplyDeletedeaddiction centre in ludhiana
ReplyDeleteشركة مكافحة النمل الابيض بالقصيم
ReplyDeleteI feel very grateful that I read this. It is very helpful and very informative and I Python training in pune really learned a lot from it.
ReplyDeleteI Got Job in my dream company with decent 12 Lacks Per Annum salary, I have learned this world most demanding course out there in the current IT Market from the python training in pune experts who helped me a lot to achieve my dreams comes true. Really worth trying.
ReplyDeleteالشركات التي توجد في منطقة مكة المكرمة والتي تعمل في مجال نقل العفش مع الفك والتركيب تلك الشركة الجيدة التي تقدم اعمال جيدة وتسمى افضل شركة نقل اثاث بجدة وهي تلك التي تختص بنقل العفش من بيت الى بيت آخر في مدينة جدة وما جاورها من مناطق تابعة لها وقد نضطر قبل نقل العفش الى المكان الجديد الى تنظيف المنزل الجديد قبل النقل من افضل شركات منطقة مكة المكرمة التي تعمل في مجال تنظيف وتعقيم المنازل تلك الشركة الجيدة التي تقدم خدمات جيدة في تنظيف المنازل من الداخل ومن الخارج مثل شركه تنظيف منازل بجده التي تختص بأعمال التنظيف للمنازل الجديدة والمفروشة ومن الأفضل ان تقوم بعمل مكافحة للحشرات بالتواصل مع افضل واقوى الشركات التي تقدم خدمات مكافحة حشرات المنزل البق والصراصير والنمل والعته تلك التي تستخدم مبيدات آمنة وفعالة وهي شركه مكافحه حشرات بجده التي تتعامل في مكافحة الحشرات وتستخدم مبيدات آمنة ومضمونة ونحتاج ايضا الى تنظيف الخزان وذلك بالتعرف على اكبر وافضل واقوى شركات تنظيف خزانات المياه بجدة تلك التي تقوم بأعمال تنظيف وتعقيم خزانات المياه في جدة بمنتهى الدقة والاحترافية وتقدم شركه نظافه خزانات بجده افضل الخدمات الجيدة في تنظيف وتعقيم الخزانات لكي تحافظ على الماء نظيفا ومعقما اطول فترة
ReplyDeleteThanks for giving great kind of information.
ReplyDeletebest website designing company in Delhi
Packers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List, Compare Charges, Save Money And Time at
ReplyDeleteLocal Packers And Movers Bangalore
Nice blog to read, Thanks for sharing this valuable article.
ReplyDeleteData Science Training In Bangalore
off white shoes
ReplyDeletesupreme clothing
hermes handbags
supreme new york
yeezy 350
kyrie 6
golden goose sale
jordan 1
yeezy 700
hermes handbags
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عيادة أحمد عبد السلام هي واحدة من أفضل مراكز تكميم المعدة في مصر يقدم مجموعة شاملة من الخدمات ويضمن فريقه من المهنيين الطبيين ذوي الخبرة أن يتلقى كل مريض أعلى جودة ممكنة من الرعاية.
ReplyDelete