Skip to Main Content

Español

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!

TRANPORTABLE TABLESAPCE can help how to correct these errors:ORA-39906 ORA-39909 ORA-39910

User_1I7HNJan 28 2021

can help how to correct these errors:

  1. ORA-39906: Constraint FK_PMD_ELEM_ID between table ROCFM.FP_ELEMENTS in tablespace TS_ROCFM and table ROCFM.PROFILE_MATCH_DETAIL in tablespace E_TS_FP_PROFILES.

  2. ORA-39909: Index ROCFM.IDX_ALERT_ID in tablespace TS_ROCFM points to table/cluster ROCFM.ARCHIVED_ALARM_CDR_CLS in tablespace E_TS_ARCHIVES.

  3. ORA-39910: Partitioned Global index ROCRA_USG.IX_5031_TD_4_TD_2 in tablespace TS_TDM_TELS_001IND points to partition P1 of table ROCRA_USG.U_TDM_TELS_004 in tablespace TS_TDM_TELS_001 outside of transportable set.

I'm doing it like this but it doesn't work:
ALTER INDEX ROCRA_USG.IX_5031_TD_4_TD_2 REBUILD partition P1 TABLESPACE TS_TDM_TELS_001;

Comments
Post Details
Added on Jan 28 2021
0 comments
385 views