Re: Strange Issue

Posted by ErmanArslansOracleBlog on Jun 10, 2024; 11:44am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Strange-Issue-tp12553p12559.html

Your issue is so specific. I have not enough info for solving it. A remote access is needed there, or lots of analysis and outputs are required for this.
Why you used datapump import in this task? Who told you that and what did you do? -> "that might me the cause of the current problem". -- This is the way you use for reloading spatial -> How To Reload Oracle Spatial (SDO) (Doc ID 2796890.1)

When you have such INVALIDs in the registry, you need to first check why they are so.. The verification fuction can tell you this.. Only then if needed you take those kinds of actions.. only in the last resort.. Normally you fix the specifics, you don't do radical big actions..