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

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 sh...
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

Food Masala Items

Wanna know what is Fennel seeds called in your language? Wanna know what is Milagu called in English or other Indian language? Check this out... Mustard (English) TAMIL - Kadugu TELUGU - Avalu KANNADA - Sasuve MALAYALAM - Katuku HINDI - Rai Cumin seeds (English) TAMIL - Jeeragam TELUGU - Jilakara KANNADA - Jeerigae MALAYALAM - Jirakam HINDI - Jeera Fennel seeds (English) TAMIL - Perumjeeragam/Sombu TELUGU - Pedha Jilakara/Sopu KANNADA - Badesopu MALAYALAM - Perumjeeragam HINDI - Moti Saunf Fenugreek seed s (English) TAMIL - Vendhayam TELUGU - Menthalu KANNADA - Menthae MALAYALAM - Uluva HINDI - Methi seeds Dry Red Chilli (English) TAMIL - Kaintha Milagai TELUGU - Mirapakayalu KANNADA - Kempu Menasina kai MALAYALAM - Unakka mulaku chuvanna HINDI - Lal michi Black peppercorns (English) TAMIL - Milagu TELUGU - Miriyalu KANNADA - Kari Menasu MALAYALAM - Kurumulaku HINDI - Kali mirch Coriander seeds (English) TAMIL - Thaniya/Malli vidai TELUG...
Read more