NOLOGGING

PROMPT Cursor para poner todas las tablas de un esquema a NOLOGGING en ORACLE
DECLARE
  CURSOR tabla IS
    SELECT TABLE_NAME
    FROM   USER_TABLES;
BEGIN
  FOR name IN tabla LOOP    
    EXECUTE IMMEDIATE 'ALTER TABLE '|| name.TABLE_NAME || ' nologging'; 
  END LOOP;
END;
/



PROMPT Cursor para poner todas las tablas de un esquema a LOGGING en ORACLE
DECLARE
  CURSOR tabla IS
    SELECT TABLE_NAME
    FROM   USER_TABLES;
BEGIN
  FOR name IN tabla LOOP    
    EXECUTE IMMEDIATE 'ALTER TABLE '|| name.TABLE_NAME || ' logging'; 
  END LOOP;
END;
/