Partition Split fails with Ora-01652
Hi all,
I am on Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
I have a Very Large Database and I am have a partition that has grown to 100Gb. I am trying to split this partition into smaller manageable partition. However I am getting the error:
ORA-01652: unable to extend temp segment by 16384 in tablespace T_DATA. The tablespace that I want to split is in tablespace T_DATA. Currently T_DATA has free space of 43GB. The index on this partition is a global one and it resides in a separate tablespace.
Could it be that ALTER TABLE split partition... requires twice as much space as the partition being split? I thought a partition split doesn't require additional space? Menaing in my case I'd need 200Gb extra if I am to split this 100Gb partition?
Please help. Thanks