Arc GIS Spatial Index error

Sometimes when you move database schema from server to another server and try to open the spatial tables in ArcCataloge or ArcMap you will face the following error because the spatial index does not updated

To solve the error which is the same as in the previous screenshot follow the following

1. Go the table in SQL developer if you use oracle
2. Go to the indexes tab 
3. find the domain index 
4. get its name 
5. Create script as the following and refresh you ArcCataloge database connection 

DROP indexName ;
CREATE INDEX theSameIndexName ON spatialTableName (geometryColumn) INDEXTYPE IS MDSYS.SPATIAL_INDEX;


Example:

DROP index A130_IX1 ;
CREATE INDEX A130_IX1 ON BACKGROUND (shape) INDEXTYPE IS MDSYS.SPATIAL_INDEX;