Cause
There is no entry in the USER_SDO_GEOM_METADATA view for the specified geometry table.
There is no entry in the USER_SDO_GEOM_METADATA view for the specified geometry table.
Insert an entry for the destination geometry table with the correct dimension information.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/10160758
https://community.oracle.com/message/10518411
https://community.oracle.com/message/864270
https://community.oracle.com/message/591134
https://community.oracle.com/message/3599103
https://community.oracle.com/message/900404
https://community.oracle.com/message/665850
https://community.oracle.com/message/153160
https://community.oracle.com/message/460222
https://community.oracle.com/message/47004
https://community.oracle.com/message/28961
https://community.oracle.com/message/4079817
https://community.oracle.com/message/3575494
https://community.oracle.com/message/25126
https://community.oracle.com/message/3599099
Browse all solutions to database errors from Oracle, MS SQL, or MySQL