Correct. The 100 MB would be available for use.
Jim
"Carlos Alberto" <calberto2312_at_hotmail.com> wrote in message
news:72954535.0205161140.5cb7bac7_at_posting.google.com...
> Hi,
>
> I have a doubt about creating indexes in parallel : suppose that I
> put a degree of 4 with 100MB extents, then Oracle will allocate 4
> processes to create the index. So, I would need at least 400 MB free
> in the tablespace. But if the index only needs 300 MB, for example,
> after itīs created, this space left (100 MB) would still be used in
> the future insertions of data on this table?
>
> Thanks in advanced,
> Carlos
Received on Thu May 16 2002 - 20:28:08 CDT
