TableSpace TEMP01 (28GB) – Solução?

[leandrolbsParticipante]

deu certo….

script:

create temporary tablespace newtemp tempfile 'C:oracleproduct10.2.0oradataORAJRTEMP02.dbf' SIZE 500M AUTOEXTEND ON NEXT 64M MAXSIZE UNLIMITED ;

--= ok

alter database default temporary tablespace newtemp;

--== ok

drop tablespace temp including contents and datafiles;

--== ok

alter tablespace newtemp rename to temp;

--== ok

select name from v$tempfile;
select tablespace_name, file_name from dba_temp_files;

--==ok