Product, Version, and relevant environment details:
Toad for Oracle 13.1.0.78
Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 - Production
• Describe the problem fully. What result was expected?
Create multiple datafiles (01 -> 07):
ALTER TABLESPACE
TEMP
ADD TEMPFILE
'/ora1/oradata/cdb18000a/bistgrip01/temp01.dbf'
size 16g
autoextend on next 512m maxsize 16g
navigate:
TOAD menu > Database > Administer > TABLESPACES
Showing datafiles of 144 gig each
Temp tablespace total = 1008 gig
expected behaviour:
Datafiles of 16 gig each
Temp tablespace total of 7 * 16 gig.
• Can the issue be created on demand or is it intermittent?
Yes, dropped tablespace en recreated it, but the result was te same.
Thanks for the clear picture of your environment and problem.
There is some wonkiness in the data dictionary regarding temporary tablespaces in pluggable databases in 18c and 19c. I've worked around it in Toad 13.2. Please give it a try there and let me know if it's working correctly.
You can get 13.2 here. Get the same bitness (32/64) as 13.1. Don't uninstall 13.1.
We are proud to announce the launch of Toad for Oracle v15.1 beta . We want to encourage you to participate in this beta program to help us to deliver a high quality product. Quest’s beta programs are your opportunity to participate in the development, direction, and testing of our products. By becoming a beta tester you have direct access to the development team and product management.
Instructions for joining the BETA program:
The Beta requires that you are running the current commercial …
We used the Toad for Oracle 13.2 Beta version and the issue is now solved. Thank you. Regards, Joost.
1 Like