Select to view content in your preferred language

ArcSDE System Tables visible in Oracle SQL Developer but invisible in ArcCatalog

647
1
04-06-2011 12:44 AM
WinnieLow
New Contributor
Hello,

I've recently installed ArcSDE for Oracle10gR2 on Windows 7 platform. I was able to view all System Tables such as COLUMN_REGISTRY, DBTUNE via Oracle SQL Developer. In addition, I can also view all the System Tables via Oracle SQL*Plus. However, when I connect to the ArcSDE geodatabase using the "Add Spatial Database Connection" in ArcCatalog, I cant see any System tables and was able to see other schema's tables.

Can someone help me to resolve this? Thanks.

Regards,
Winnie
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
That behavior is by design, to reduce clutter.  The other schema's tables might just
be feature datasets (owned by other users, but not accessible because one or more
of the tables within are not SELECTable).

- V
0 Kudos