AnsweredAssumed Answered

index Rnnn_SDE_ROWID_UK

Question asked by Eric_V on Dec 17, 2015
Latest reply on Dec 18, 2015 by Eric_V

Hi everyboby.

When I register a table and a layer with the following commands :

 

sdetable -o register -t EDMC_GEOMT_REGN_ADMNS -c IDE_GEOMT_REGN_ADMNS -C USER -k SDO -i sde:oracle11g:lbl01-scan.mtq.min.certif/OL1220.WORLD -u schema_user -p password

 

sdelayer -o register -l EDMC_GEOMT_REGN_ADMNS,GEO_REGN_ADMNS -t SDO_GEOMETRY -C IDE_GEOMT_REGN_ADMNS -e na+ -k SDO -R 2 -i sde:oracle11g:lbl01-scan.mtq.min.certif/OL1220.WORLD -u schema_user -p password

 

The existing PK index on IDE_GEOMT_REGN_ADMNS column is dropped and an Rnnn_SDE_ROWID_UK index is created for the same column (IDE_GEOMT_REGN_ADMNS).

 

This append only for 5 tables. All others tables with same kind of geometry stay unchanged. The PK index is still there after registration.

 

What can produce this effect (drop of the PK and creation of a UK) ?

 

Thanks for your help.

Outcomes