Insert Into USER_SDO_NETWORK_USER_DATA Fails With Errors ORA-13385, ORA-06512, ORA-04088 error during execution of trigger 'MDSYS.SDO_NETWORK_UD_INS_TRIG' (Doc ID 1919997.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

How to avoid the error below while Attempting to insert into USER_SDO_NETWORK_USER_DATA without entering the the required data into USER_SDO_NETWORK_METADATA

ORA-13385: error in network manager: [SCOTT.TIGER_ROAD NOT IN NETWORK METADATA!]
ora-06512: at "MDSYS.MD", line 1723
ORA-6512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_NETWORK_UD_INS_TRIG", line 14
ORA-04088: error during execution of trigger 'MDSYS.SDO_NETWORK_UD_INS_TRIG'
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms