Home » Server Options » Spatial » Getting Errors
Getting Errors [message #170721] Thu, 04 May 2006 23:14 Go to next message
Messages: 2
Registered: May 2006
Junior Member
I am trying to do following

INSERT INTO user_sdo_geom_metadata VALUES

When I executed it for the first time it did not give any errors but afterwords it is giving error

insert into user_sdo_geom_metadata values
ERROR at line 1:
ORA-00001: unique constraint (MDSYS.UNIQUE_LAYERS) violated
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 27
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'

Is it happening because I am trying to give meta-data for same table again.

Re: Getting Errors [message #172644 is a reply to message #170721] Wed, 17 May 2006 08:13 Go to previous message
Messages: 4
Registered: May 2006
Junior Member

It doesn't make sense to have more than one metadata-entry for a given column...
Previous Topic: OCI -> PL/SQL Conversion?
Next Topic: ORA-13193: failed to allocate space for geometry
Goto Forum:

Current Time: Mon May 17 12:26:38 CDT 2021