SDE Lineages count and some commands

Connect as sde login in your database through Sql

sql> SELECT COUNT(*) FROM sde.state_lineages WHERE lineage_name NOT IN (SELECT DISTINCT lineage_name FROM sde.states);

Versions names and State_ID
SELECT name, state_id FROM sde.versions;

States count

SELECT COUNT(*) FROM sde.states;

Comments

Post a Comment

Popular posts from this blog

Create Blank/Empty MXD with Same Symbology

Image
Create an Empty MXD in ArcGIS 10 with same symbology from previously used for accessing data . Follow the below steps. 1. Open the ArcCatalog -> Go to the MXD ( Which you want create blank from the Existing MXD)  Right click and select the Set Data Source 2. In the above snap shot you can identify Output File - It changes the name of "Copy of" and then click a Select all option next click Replace button then Replace with button make it as Null (Remove the path). Then it will create a new MXD with a Copy of name.Please check the below snap shot
Read more

ARC2EARTH Installation Problem in ArcGIS 10

If you unable to add the Arc2Earth tool bar in ArcGIS 10. Registration problem for the tool. So that need to register the tool. Go to Run command and enter like below 1st Step For 64-Bit cd C:\Program Files (x86)\Common Files\ArcGIS\bin 2nd step ESRIRegAsm /p:Desktop "C:\Program Files (x86)\Arc2Earth LLC\Arc2Earth\KMLExporter.dll" For 32 -Bit cd C:\Program Files\Common Files\ArcGIS\bin 2nd step ESRIRegAsm /p:Desktop "C:\Program Files\Arc2Earth LLC\Arc2Earth\KMLExporter.dll" Now Registration Succeeded prompt will come. Close all existing ArcGIS browser. Then Open the new browser. add the the arc2earth tool bar. It should come.
Read more

ORA-00001;unique constraint error

Image
If you get above - ORA-00001;unique constraint error R****_sde_ROWID_UK violated connect the sde server and get the ROWID numbers using below statements. Please enter one by one relationship with having table and match the number with error number. That relationship having the duplicate indexid (RID field). example sdetable -o describe_reg -t MJEC.SupportStructure_Fuse -u sde -p sde answer 418 sdetable -o describe_reg -t MJEC.SupportStructure_Switch -u sde -p sde answer 426 sdetable -o describe_reg -t MJEC.SupptStruct_MiscNetworkFeat -u sde -p sde answer 422 sdetable -o describe_reg -t MJEC.SupptStruct_PFCorrectEquip -u sde -p sde answer 424 sdetable -o describe_reg -t MJEC.SupptStruct_Streetlight -u sde -p sde answer 423 sdetable -o describe_reg -t MJEC.SupptStruct_Transformer -u sde -p sde answer 416 sdetable -o describe_reg -t MJEC.SupptStruct_VoltBoostTrans -u sde -p sde answer 425 Snapshot shows the 416. 416 is regarding to M
Read more