topic ArcSDE Views or Oracle Views? in ArcGIS API for Silverlight Questions https://community.esri.com/t5/arcgis-api-for-silverlight-questions/arcsde-views-or-oracle-views/m-p/320837#M8302 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><SPAN>I have created a layer in ArcMAP using </SPAN><STRONG>Make Route Event Layer</STRONG><SPAN>(ArcToolBox) from a view created in oracle but I am unsure if I am doing it right here..</SPAN><BR /><BR /><SPAN>I have created views in Oracle, is it tat I have to create a view of tables in&nbsp; ArcSDE called arcsde views as mentioned below</SPAN><BR /><A href="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Using_database_views">http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Using_database_views</A><BR /><BR /><SPAN>Please guide...</SPAN></BODY></HTML> Tue, 08 Mar 2011 09:55:55 GMT SantoshV 2011-03-08T09:55:55Z ArcSDE Views or Oracle Views? https://community.esri.com/t5/arcgis-api-for-silverlight-questions/arcsde-views-or-oracle-views/m-p/320837#M8302 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><SPAN>I have created a layer in ArcMAP using </SPAN><STRONG>Make Route Event Layer</STRONG><SPAN>(ArcToolBox) from a view created in oracle but I am unsure if I am doing it right here..</SPAN><BR /><BR /><SPAN>I have created views in Oracle, is it tat I have to create a view of tables in&nbsp; ArcSDE called arcsde views as mentioned below</SPAN><BR /><A href="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Using_database_views">http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Using_database_views</A><BR /><BR /><SPAN>Please guide...</SPAN></BODY></HTML> Tue, 08 Mar 2011 09:55:55 GMT https://community.esri.com/t5/arcgis-api-for-silverlight-questions/arcsde-views-or-oracle-views/m-p/320837#M8302 SantoshV 2011-03-08T09:55:55Z Re: ArcSDE Views or Oracle Views? https://community.esri.com/t5/arcgis-api-for-silverlight-questions/arcsde-views-or-oracle-views/m-p/320838#M8303 <HTML><HEAD></HEAD><BODY><SPAN>You're on the right track. You've created a view in Oracle, now the next step is to 'register' that view with SDE, so SDE can serve the data out to ArcGIS as though it were a normal registered SDE table. (By default SDE will ignore your newly created view.) Run </SPAN><SPAN style="font-style:italic;">sdetable -o create_view</SPAN><SPAN> with all the parameters just as the documentation says (warning: the command is very picky about every parameter, be ready to tinker) and SDE should recognize your oracle view and you will be able to see it in ArcCatalog, etc.</SPAN><BR /><BR /><BR /><BR /><SPAN>PS - in the future you should post server related questions in the </SPAN><A href="http://forums.arcgis.com/forums/8-ArcGIS-Server-General">server forum</A><SPAN>. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Tue, 08 Mar 2011 11:12:19 GMT https://community.esri.com/t5/arcgis-api-for-silverlight-questions/arcsde-views-or-oracle-views/m-p/320838#M8303 DanielWalton 2011-03-08T11:12:19Z