Script de manutenção de Tablespace temporária

/*
manutenção na tablespace temporária
*/

CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE 'E:\ORACLE\PRODUCT\ORADATA\DTSTR2\TEMP001.DBF' SIZE 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;

ALTER USER MAXIMO TEMPORARY TABLESPACE TEMP1;
/*
SELECT
                'ALTER USER ' || USERNAME || ' TEMPORARY TABLESPACE TEMP1;'
FROM
                DBA_USERS;
*/

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;

CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\ORACLE\PRODUCT\ORADATA\DTSTR2\TEMP01.DBF' SIZE 10000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

ALTER USER MAXIMO TEMPORARY TABLESPACE TEMP;
/*

SET PAGES 9999

SELECT
                'ALTER USER ' || USERNAME || ' TEMPORARY TABLESPACE TEMP;'
FROM
                DBA_USERS;
*/

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

DROP TABLESPACE TEMP1 INCLUDING CONTENTS AND DATAFILES;