I've got two temporary tablespaces TEMP and TEMP02:
select file_name from dba_temp_files where tablespace_name = 'TEMP';
select file_name from dba_temp_files where tablespace_name = 'TEMP02';
User System uses tablespace TEMP02 and user Sys uses tablespace TEMP.
Problem is TEMP01.DBF is quite large and I would like to reduce it. But how? Maybe if I do:
alter user SYS temporary tablespace Another_Table_Space;
I would spoil a lot of things... Could anyone give me an example of what to do, please?