|
-
Now that it seems to be working, I've ran into one small issue. Turning on Parallel=true will cause SQL Loader to not rebuild indexes (hence the skip_index_maintenance=true option to get this to work).
Does anybody have a good method / script for indentifying all indexes for a particular schema and then rebuilding indexes?
The only thing I can think of is spooling off some command like:
select 'alter index ' || index_name || ' rebuild; ' from user_indexes where table_name='MYTABLE';
That will create my sql list.. but it also spools off the select / spool off commands.
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
|