locked
UPDATE on partition RRS feed

  • Question

  • Hi I am running 9.2i and need to do updates on whole partition.

    Now the update is in procedure.
    My question is there any way to do this update faster?

    PROCEDURE run_update_on_partition_1
    IS
    BEGIN
    UPDATE my_table PARTITION(partition_1)
    SET city = DBMS_RANDOM.STRING ('A', 40),
    street = DBMS_RANDOM.STRING ('A', 60);
    EXCEPTION
    WHEN OTHERS
    THEN
    DBMS_OUTPUT.put_line ('Error ' || SQLERRM);
    END run_update_on_partition_1;

    Thanks
    Thursday, November 22, 2007 4:29 PM