you can user DBMS_JOBS to execute an update procedure every n time.