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?
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-ora...
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!
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
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