# Toad 10.6 & datafile definitions **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [May 8, 2013, 6:12pm UTC](https://forums.toadworld.com/t/toad-10-6-datafile-definitions/18191 "2013-05-08T18:12:41Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![peter.croft\_890](https://avatars.discourse-cdn.com/v4/letter/p/f0a364/32.png) [@peter.croft\_890](https://forums.toadworld.com/u/peter.croft_890)\ **Post date:** [May 8, 2013, 6:12pm UTC](https://forums.toadworld.com/t/toad-10-6-datafile-definitions/18191/1 "2013-05-08T18:12:41Z")
I have recently been upgraded to toad v10.6.0.42 from v9 & am puzzled by what I see in a datafile definition. I don’t understand why the maxsize unlimited is greater than the datafile size. Has there been a change to the way Toad calculates available & free space etc? For example I have a datafile that showed 4000MB in size but max extendable size was 1GB. I changed max size to 4.5GB & now the max size shows 512MB! Can anyone advise? ---
**Author:** ![peter.croft\_890](https://avatars.discourse-cdn.com/v4/letter/p/f0a364/32.png) [@peter.croft\_890](https://forums.toadworld.com/u/peter.croft_890)\ **Post date:** [May 9, 2013, 8:36pm UTC](https://forums.toadworld.com/t/toad-10-6-datafile-definitions/18191/2 "2013-05-09T20:36:22Z")
On further investigation it looks like Toad is displaying 512MB when it should display 5120MB unless of course there has been a change in v10 where the max size now shows extensible space remaining? Can anyone confirm this? Tha datafile I altered now shows: /dpp/gis/GISLIVE/os\_tables01.dbf 4000 4608 using select file\_name, bytes/1024/1024 “Size in MB”, maxbytes/1024/1024 “Max in MB” from dba\_data\_files where tablespace\_name = ‘table\_name’; for bytes & maxbytes respectively which reflects the change I made to 4.5GB & If I look at 2 other datafiles that in Toad show as 1GB maxsize they show as 5GB maxsize as follows: /dpp/gis/GISLIVE/os\_tables03.dbf 3970 5120 /dpp/gis/GISLIVE/os\_tables02.dbf 3770 5120 i.e. maxsize is actually 5GB & not 512MB. 512MB makes sense for tables01 if ‘space remaining’ is correct. Apologies if this is obvious to v10 users out there but I found it quite confusing.