Oracle Spatial Is Valid But Some Types Are Still Invalid After Catalog and Catproc
(Doc ID 1299348.1)
Last updated on JANUARY 31, 2022
Applies to:
Oracle Spatial and Graph - Version 10.2.0.4 to 11.2.0.2 [Release 10.2 to 11.2]Information in this document applies to any platform.
Symptoms
After validating the options running
1. connect to the database as sysdba:
sqlplus "/ as sysdba"
2. shutdown immediate
3. startup upgrade
4. spool catalog.log
spool off
7. shutdown immediate
8. startup
Your DBA_REGISTRY shows all components VALID
But you still have invalid types owned by MDSYS:
MDSYS TYPE SDO_GEO_ADDR
MDSYS TYPE SDO_LINK_I
MDSYS TYPE SDO_NETWORK_I
MDSYS TYPE SDO_NETWORK_MANAGER_I
MDSYS TYPE SDO_NODE_I
MDSYS TYPE SDO_TGL_OBJECT_ARRAY
These types also have VALID versions of themselves
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |