create a index rebuilding script
i want to make a index rebuilding script and get in spool file at what time which index was getting rebuilded.
i tried set time on , but that doesnt work in spool file.
i used set timi on . that is working working fine but that only gives how much tiime taken by an index to rebuild but does not show at what time(sysdate).
is there any option by which i can get time(eg. 1march 12:30:00) in spool file to come to know at what time which index was getting rebuilded.