Received the following error when trying to run ora_cleansp:
.....
......
SQL>
Table altered.
SQL>
Table truncated.
SQL>
Table truncated.
SQL> alter table SHAREPLEX_OOS_MASTER enable constraint SHAREPLEX_OOS_MASTER_PK
*
ERROR at line 1:
ORA-00959: tablespace '_$deleted$150$0' does not exist
SQL> alter table SHAREPLEX_OOS_KEYS enable constraint SHAREPLEX_OOS_KEYS_FK
*
ERROR at line 1:
ORA-02270: no matching unique or primary key for this column-list
SQL> SQL>
Commit complete.
Default tablespace for Shareplex user is set to tablespace that is not exist in the database.
1. Correct the default tablespace for Shareplex user.
2. Rerun ora_cleansp
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center