Toad World® Forums

Toad 10.6 & datafile definitions

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?

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.