DECLARE
V_INDNAME VARCHAR2(100);
CURSOR C_IDX IS SELECT INDEX_NAME FROM USER_INDEXES WHERE LOGGING = 'NO';
BEGIN
OPEN C_IDX;
LOOP
FETCH C_IDX INTO V_INDNAME;
EXIT WHEN C_IDX%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('ALTER INDEX '|| V_INDNAME ||' LOGGING;');[/COLOR]
END LOOP;
CLOSE C_IDX;
END;
DECLARE
V_INDNAME VARCHAR2(100);
V_SQL VARCHAR2(1000);
CURSOR C_IDX IS SELECT INDEX_NAME FROM USER_INDEXES WHERE LOGGING = 'NO';
BEGIN
OPEN C_IDX;
LOOP
FETCH C_IDX INTO V_INDNAME;
EXIT WHEN C_IDX%NOTFOUND;
V_SQL:='ALTER INDEX '|| V_INDNAME ||' LOGGING';
DBMS_OUTPUT.PUT_LINE(V_SQL);
execute immediateV_SQL;
END LOOP;
CLOSE C_IDX;
END;