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:
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:
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.