Temporary tablespace creation datafile has numbers appended
This is Oracle 19.22 Enterprise running on Rocky OS8.9
Creating a new or existing database, i run through a script which gives me the temporary tablespaces i need.
The weird thing is that Oracle will append a trailing digit to the temp data files i create...
Create bigfile local Temporary Tablespace FOR ALL TEMP_TEMP Tempfile '/oracle/oradata/DOCSDEV/data/temp_temp.dbf' Size 100M Autoextend On Next 100M Maxsize 18000M Extent Management Local Uniform Size 1024k;
this creates a data temp file /oracle/oradata/DOCSDEV/data/temp_temp.dbf_1
Where is the '_1' coming from??
Same with another temp file create: