|
-
Hi
Can any body advice me how can i create simple indexes rebuild scripts on NT or 2000 so I can make it as a batch file to run weekly ???
Currently i am doing this manually at CMD prompt.
alter index sapr3."ARFCSSTATE0" rebuild;
alter index sapr3."ARFCSSTATE~01" rebuild;
etc....
I have found this under Oracle Scripts,
Description:
This script will rebuild a list of indexes.
Code:
select 'alter index '|| index_name || ' rebuild nologging;' from dba_indexes where owner = ' ' --insert database name here
Would this script apply in my case and how can i use it.
Thanks
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
|