I want to create a locally managed temporary table space with multiple temp files, the database is Oracle 8i. I searched online for a statement, and I was able to find one which is
create temporary tablespace "TEMP3"
tempfile '/ordata/DB_NAME/data/temp_01.dbf' size 100M autoextend on next 10M maxsize 500M
extent management local
uniform size 64K
How I can modify it to allow two or more temp files instead of one?