We have a report that identifies which database managed system tablespaces are in need of extending (for us that is when the get below 30% free space). This morning I used Toad 184.108.40.2063 to extend one of these tablespaces. To do this I did the following steps:
- In the database go to tablespaces tab and select and right click on the offending tablespace.
- Select Space Management/Identify Exceptions. This brings up a report that includes free space % which was at 28%.
- Right click on the tablespace and select alter and then use this process to resize the tablespace.
Everything was good up to here. The script to resize the tablespace worked just fine. But when I got back out to the tablespace level and did Space Management/Identify Exceptions expecting to see the new allocations it was the old allocations. I tried “Refresh Item” on the tablespace level to no avail. The ONLY thing I could figure out was to disconnect and reconnect to the database. Am I doing something wrong here?