Temp Tablespaces, data files with autoextend causes max size is to be displayed less than tablespace (4270312)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Temp Tablespaces, data files with autoextend causes max size is to be displayed less than tablespace
Description

In the Toad for Oracle schema browser, the Temp tablespace Max size is less than tablespace size.
(See attached screenshot)

After tracing the SQL to extract the tablespace, the SQL to extract Temp tablespace is incorrect.
You need a temporary tablespace with more than one data files files with autoextend on some of the datafiles.
Cause

The problem is caused by this line:
round(sum(f.maxbytes) / 1048576) max
The code only "sums" the max, it doesn't test the autoextend flag.
Resolution

This issue was fixed in Toad 12.0. The latest version of Toad can be downloaded here .
Defect ID

CR107051
Attachments

Temp Tablespaces, data files with autoextend causes max size is to be displayed less than tablespace
Additional Information

Scheduled for fix in next beta past 12.0.0.24

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title