ERROR CREATING INDEXES OC 4.6
(Doc ID 972392.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Clinical - Version 4.6.0 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |