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.