A script referencing sde.gdb_items_vw gives ORA-00942: table or view does not exist

[TimLangner]

Hi there

I am trying to locate which fields domains are being used by. I am using ArcMap 10.1 but accessing a 9.3.1 geodatabase stored in an Oracle 10.2g database,

There was a a script on the following page:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000t9000000

However when ever I run it I get the error:
ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"

It is for the table sde.gdb_items_vw which does not exist. Would anyone happen to know why it might not exist?

I am trying to delete a domain but before I can do so, I need to remove it from a field but I need to see which field(s) are still referencing it.

Kind regards


Tim

[VinceAngelo]

That script assumes 10.x geodatabase; 9.3.1 doesn't have the same organization.

- V

[TimLangner]

Thanks for pointing that out Vangelo.

Is their a list of tables used in 9.3.1 or even a comparison chart which shows the table name differences between version side by side?

Kind regards

Tim

[VinceAngelo]

The geodatabase table structures are documented in each release.  The changes
at 10.0 were highlighted in "What's New" pages and multiple other forms during
10.0 rollout.  There is no table comparison between 9.x and 10.x though, since
the strucutre is so radically different (the relationships are now stored in XML).

- V

[TimLangner]

Thank you for that. I will look through the What's new sections.