# Remembering last datafile parameters in new datafile dialogue **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [March 17, 2023, 6:15pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161 "2023-03-17T18:15:54Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![rjesse](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rjesse/32/156_2.png) [@rjesse](https://forums.toadworld.com/u/rjesse)\ **Post date:** [March 17, 2023, 6:15pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/1 "2023-03-17T18:15:54Z")
Howdy, All of our Oracle DBs use OMF, so when I need to add a datafile, it is exactly the same -- OMF checked, size 100MB, Auto Extend, Next Extent 100MB, Maximum size 32767MB. I could have sworn that this info was saved in Toad. In my last job, I probably added 1 datafile every month or two, but now it's several per week. Am I missing a Toad setting, or is this an Idea Pond thing? Thanks! Rich O'Toadie ☘ ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 17, 2023, 6:37pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/2 "2023-03-17T18:37:53Z")
Hi Rich, Hm, looks like stuff under "Autoextend" and the Oracle Managed File box are saved. File size isn't saved, and you have to check "autoextend" to get the stuff under it to load from ini settings. Is that what you are seeing? Another user brought up a problem with the max size box. Looks like we might have a problem with that here too. I'll check it out. -John ---
**Author:** ![rjesse](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rjesse/32/156_2.png) [@rjesse](https://forums.toadworld.com/u/rjesse)\ **Post date:** [March 17, 2023, 6:52pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/3 "2023-03-17T18:52:29Z")
Hey John, Almost...our standard datafile max size is 32GB-1MB, or 32767MB. There is a method to that madness, born of Oracle bugs in versions (hopefully?) gone by. Toad translates this as "UNLIMITED" though, perhaps by rounding in GB vs MB? Thanks! Rich ---
**Author:** ![DougK](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@DougK](https://forums.toadworld.com/u/DougK)\ **Post date:** [March 17, 2023, 7:06pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/4 "2023-03-17T19:06:58Z")
Keep in mind that the actual SMALLFILE maxsize is determined by the block size. [https://logic.edchen.org/how-max-a-data-file-can-be/](https://logic.edchen.org/how-max-a-data-file-can-be/) ![~WRD000.jpeg](https://global.discourse-cdn.com/quest/original/2X/5/52d5f1c08649212fe6768d2cacdcf8df711810d9.jpeg) ---
**Author:** ![rjesse](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rjesse/32/156_2.png) [@rjesse](https://forums.toadworld.com/u/rjesse)\ **Post date:** [March 17, 2023, 7:30pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/5 "2023-03-17T19:30:38Z")
Right. Sorry, it's been decades since I've used anything but 8K blocks. 🙂 We have set our datafiles to have a max size of 32767x1024x1024 (32767MB) instead of the database maximum of 32x1024x1024x1024 (32768MB or 32GB) for the 8K blocksize. Thanks, Rich p.s. "MB" and "GB" here are how Toad references 1024x1024 and 1024x1024x1024, respectively. Which is the correct way in I.T., despite the terms being redefined as "MiB" and "GiB" in the late 90s by some commission. _[drops mic, steps off soapbox and runs away from the angry mob]_ ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 17, 2023, 8:13pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/6 "2023-03-17T20:13:12Z")
Fixed for 17.0. You'll still have to enter a file size (if you want to specify it, at least) And if you check autoextend, we'll fill in the stuff underneath with your last used values. Toad translates the appropriate "large maxsize" to unlimited 4194302 blocks for smallfile. 4294967293 blocks for bigfile ---
**Author:** ![rjesse](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rjesse/32/156_2.png) [@rjesse](https://forums.toadworld.com/u/rjesse)\ **Post date:** [March 17, 2023, 9:45pm UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/7 "2023-03-17T21:45:15Z")
Thanks John! May your beer be green and flow like wine! Erm....or something like that... 😉 Rich ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 18, 2023, 3:14am UTC](https://forums.toadworld.com/t/remembering-last-datafile-parameters-in-new-datafile-dialogue/57161/8 "2023-03-18T03:14:32Z")
Thanks Rich! Dodge, duck, dip, dive, and dodge —Patches O’Houlihan