ERROR CREATING INDEXES OC 4.6 (Doc ID 972392.1)

Last updated on DECEMBER 21, 2009

Applies to:

Oracle Clinical - Version: 4.6 - Release: 4.6
Information in this document applies to any platform.

Symptoms

ISSUE:
--------
ORA-01630 during the Oracle Clinical upgrade (4.5.3 to 4.6). The stack error is:

Creating index DISCREPANCY_ENTRIES_PERF_IDX on DISCREPANCY_ENTRIES table...
DISCREPANCY_ENTRIES_PERF_IDX ON DISCREPANCY_ENTRIES (
*
ERROR at line 2:
ORA-01630: max # extents (99) reached in temp segment in tablespace
RXC_DISC_IDX_TSPA


Creating index DATA_CLARIFIC_FORMS_PERF_IDX on DATA_CLARIFICATION_FORMS table...
DATA_CLARIFIC_FORMS_PERF_IDX on DATA_CLARIFICATION_FORMS (
*
ERROR at line 2:
ORA-01630: max # extents (99) reached in temp segment in tablespace
RXC_DISC_IDX_TSPA


Creating index DATA_CLARIFIC_FORMS_CS_NFK_IDX on DATA_CLARIFICATION_FORMS table...
DATA_CLARIFIC_FORMS_CS_NFK_IDX on DATA_CLARIFICATION_FORMS (
*
ERROR at line 2:
ORA-01630: max # extents (99) reached in temp segment in tablespace
RXC_DISC_IDX_TSPA


Creating index received_pages_perf_idx on received_pages table...
received_pages_perf_idx on received_pages (
*
ERROR at line 2:
ORA-01630: max # extents (99) reached in temp segment in tablespace
RXC_LI_IDX_TSPA


Creating Index DCF_DISCREPANCY_HIST_PERF_IDX on DCF_DISCREPANCIES_HIST ...
DCF_DISCREPANCY_HIST_PERF_IDX ON DCF_DISCREPANCIES_HIST (
*
ERROR at line 2:
ORA-01630: max # extents (99) reached in temp segment in tablespace
RXC_DISC_IDX_TSPA


Creating Index DCF_DISCREPANCY_HIST_PERF2_IDX on DCF_DISCREPANCIES_HIST ...
DCF_DISCREPANCY_HIST_PERF2_IDX ON DCF_DISCREPANCIES_HIST (
*
ERROR at line 2:
ORA-01630: max # extents (99) reached in temp segment in tablespace
RXC_DISC_IDX_TSPA


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms