-
alter index rebuild - where sorted ?
hi,
i often ran into a situation to rebuild large indices (approx. 4GB) -and sometimes i ran into ora-01652.
TBS is 6GB overall, 3.7GB are used, TEMP is about 7.6GB, 3GB are used.
my question is how to determine in general a percentage of free space (e.g. 50%) to 'alter index rebuild' or a decision to prefer to drop and re-create them ?
thanks in advance
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
|