|
-
create a index rebuilding script
hi all,
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|