ORA-30373: Object Data Types Are Not Supported In This Context , when creating Materialized View

If you face this error while creating materialized view:


ORA-30373: Object Data Types Are Not Supported In This Context

This means you are trying to create a Materialized View that references columns data types such as XMLTYPE or SDO_GEOMETRY or ESRI ST_GEOMETRY. This is a 12c limitation.

On the other hand, if you try to crate a materialized view with ST_GEOMETRY column this won’t be allowed.The workaround is not including the ST_GEOMETRY attribute in the materialized view.


Oracle Spatial Error ORA-29532: Java call terminated by uncaught Java exception ORA-06512: at “MDSYS.SDO_UTIL”, line 196

This error is received in 11g release, but fixed in 12c release :


ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException
ORA-06512: at “MDSYS.SDO_UTIL”, line 196

is there any workaround for this problem in 11g …. YES:

1. Drop the spatial index on the geometry table
2. Run the update
3. Rebuild the spatial index


sqlplus error ORA-12560

This could be known and primitive to many people, however i am putting it to help the community in general from different technical-levels.

when you initiate sqlplus and trying to connect to your database instance you face the following error:

ORA-12560: TNS:protocol adapter error


if you are using windows OS, you need to check the following:

  1. check that the database services is up and running, go to the search icon and search for “services” and ensure all Oracle services are up and running.
  2.   if Oracle database is up and running fine, then check your environment variables in  CMD, you need to set the following:


set ORACLE_HOME=D:\app\db33\product\12.1.0\dbhome_33


set PATH=D:\app\db33\product\12.1.0\dbhome_33\bin

to check that its reflected, execute the following to verify the value of ORACLE_HOME:


windows cmd oracle environment variables

now try initiating sqlplus and it will be working 🙂