topic Geodatabase opened in oracle in Data Management Questions

Geodatabase opened in oracle

santhoshT — Tue, 08 Feb 2022 10:42:22 GMT

I can able to log in to geodatabase in SQL developer and Arc catalog.

In the SQL developerI could see some junk tables names (A00, A10, B1, C5,----) but in the ArcCatalog don't find them.

Is this normal or any issues.

Could pls advise?

Re: Geodatabase opened in oracle

George_Thompson — Tue, 08 Feb 2022 11:06:35 GMT

There are many different tables that make up the Enterprise Geodatabase that are hidden by the ArcGIS client. I would say that is normal, unless you are having an issue with any of your data.

Here is some documentation to help with the system tables that you will not see in the client:

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/geodatabase-system-tables-oracle.htm

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/dataset-internal-tables.htm

Let us know if you have any other questions. Thanks!

Re: Geodatabase opened in oracle

VinceAngelo — Thu, 10 Feb 2022 02:35:25 GMT

Please do not DROP any "junk" tables without confirming that they *are* junk, or you might get to exercise your disaster recovery plan sooner than later.

- V

Re: Geodatabase opened in oracle

VinceAngelo — Fri, 11 Feb 2022 00:09:51 GMT

And it's probably wise to not create any tables named in the form <Alpha><digit>(<digit>)... All my junk tables start with "tmp" or "xx" or "junk" for that very reason.

- V