Product, Version, and relevant environment details:
Toad for Oracle 188.8.131.52
Oracle Database 18c Standard Edition 2 Release 184.108.40.206.0 - Production
• Describe the problem fully. What result was expected?
Create multiple datafiles (01 -> 07):
autoextend on next 512m maxsize 16g
TOAD menu > Database > Administer > TABLESPACES
Showing datafiles of 144 gig each
Temp tablespace total = 1008 gig
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.