Réinitialiser le tablespace temporaire

    CREATE TEMPORARY TABLESPACE temp2 TEMPFILE '/chemin complet/temp2.dbf' SIZE 50M AUTOEXTEND ON NEXT 3M;

Affectation de ce tablespace TEMP2 comme tablespace temporaire par défaut de la base :

    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

    DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

    CREATE TEMPORARY TABLESPACE temp TEMPFILE '/chemin complet/temp01.dbf' SIZE 1024M AUTOEXTEND OFF;

    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

    DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;