SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to create Index on Large Tables

Kumar62Feb 16 2015 — edited Feb 16 2015

Hi All,

We have bulk tables having around 40 crore records and these tables do not have any primary keys nor any indexes.
When trying to create composite index on identified column'S, the create index command is getting stuck
and occupying lot of table space and running out of memory and giving the below error

"Error ORA-01652: Unable to extend temp segment by 128 in table space TEMP"

Could any one Please let me know how to come out of this.

Appreciate your help on this.

Thanks,

Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2015

Added on Feb 16 2015

16 comments

2,457 views