Fix local temporary #oracle

local.md

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;
/