Way to find version of SDE

[FarooqMunir]

Hi,

Just wanted to ask, is there an easy way to find out the version of SDE running either from ArcCatalog or just by logging onto Oracle ?

Thanks,

FM

[SachinChand]

Vince, thanks for the quick response.  What about an instance where all versions are 10.  ArcGIS Desktop is then updated to v10.1.  From desktop, the sde geodatabase is upgraded to v10.1 which would still leave ArcSDE at v10.

[VinceAngelo]

No, after you upgrade the geodatabase, the SDE is at that level.  If you have an application
service, and you fail to delete and recreate it, that's an error.

- V

[SachinChand]

Ok, so with the scenario I presented, an sde service would need to be recreated, understood.  Direct connect should work fine though (after upgrading the geodatabase to v10.1 using desktopv10.1), right.

[VinceAngelo]

Correct.  Direct Connect is its own ArcSDE server.

- V

[SachinChand]

Thanks for the clarifications!

[VinceAngelo]

Please start new questions in a new thread.

Views are just views; there's nothing release-specific about a view.  Any necessary changes would
either happen to the underlying ST_GEOMETRY object, or to the base table's triggers.

- V

[NorlizaAbdul_Rahman]

sqlplus sde/password;

select all from sde.version;

[Bud]

I was able to use that query from a user/schema/owner other than SDE (a ROADS user):

--Oracle 18c
select * from sde.version;

It produced the correct information.

[arahman_mdmajid]

This worked for me. Thanks