Database Administration (MOSC)

MOSC Banner

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center