DECLARE CURSOR c1 IS SELECT 'alter user ' || username || ' LOCAL TEMPORARY TABLESPACE ' || TEMPORARY_TABLESPACE FROM dba_users WHERE username NOT IN ('XS$NULL') AND local_temp_tablespace = 'SYSTEM'; execme VARCHAR2(32767);
BEGIN
DBMS_OUTPUT.enable(32767);
OPEN c1;
LOOP
FETCH c1 INTO execme;
EXIT WHEN c1%NOTFOUND;
BEGIN
execute immediate execme;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ('Error code: ' || SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 64));
DBMS_OUTPUT.put_line ('Error sql: ' || execme);
END;
END LOOP;
CLOSE c1;
END;
/