-
Hi Guys,
I'm adding 24 months to a date column on a large table.
This column has a bitmap index on it.
I've not dropped the index, so as the column updates, so does the index.
Here's the problem..................
The index runs out of space with an error message:-
unable to extend index OMNPLUS_DEV.BDX_DATE_LAST_MOVED by 64
in tablespace OMNPLUS_INDEX
Why does it run out of space ? I've not added any rows, I'm just updating the current rows, so, theoretically, the index size will remain the same.
Why does it need to allocate a new extent ?
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
|