index error after using transportable tablespace
Hi,
using oracle 12.2 EE RAC.
Seems worked fine, except one error during tablespace meta data import:
EIDDB.SYS_C00128739 : sqlerrm = ORA-20000: Unable to set values for index SYS_C00128739: does not exist or insufficient privileges
Importing statistics failed for 1 object(s);
The index is a pk on a table that has childs. Cannot rebuild index, oracle tells it does not exist
But it is visible in sql developer:
SYS@BORO1 2024-02-11 09:46:19> alter index eiddb.SYS_C00128739 rebuild online tablespace cardusers;
alter index eiddb.SYS_C00128739 rebuild online tablespace cardusers
*
ERROR at line 1:
ORA-01418: specified index does not exist
SYS@BORO1 2024-02-11 09:47:03> Select * from dba_indexes where index_name='SYS_C00128739';