Hi, I am Anisim and i am big trouble. I installed Oracle 11gR2 and ArcSDE 10.1. I created an Enterprise Geodatabase with , then I added a Database Connection on the new geodatabase. We found that the database is not empty! There are many tables oracle! Why? Thank you very much, Anisim

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcSDE/new Geodatabase is not empty

AnisimDesya

Hi,

I am Anisim and i am big trouble.
I installed Oracle 11gR2 and ArcSDE 10.1.
I created an Enterprise Geodatabase with <Create Enterprise Geodatabase>, then I added a Database Connection on the new geodatabase.

We found that the database is not empty! There are many tables oracle!

Why?

Thank you very much,
Anisim

Find more posts tagged with

Accepted answers

VinceAngelo

I requested the table list as ASCII in the post because others could then
search on the table names and find this thread. Attachments are not
searchable, so no one will find the references to these SCOTT, IX, OE, SH,
or HR tables.

If you install Oracle from scratch, rather than using the pre-built database
filled with samples, and disable the capabilities you don't need, there will
be far fewer "junk" tables clogging up your instance. These tables have
nothing to do with ArcSDE or geodatabase functionality, so you may
ignore them, or drop the users (with CASCADE), or reinstall Oracle as
you see fit. But I would recommend some Oracle training, so you can
better recognize trouble when it arrives.

- V

All comments

VinceAngelo

AnisimDesya

Please provide the list of tables that have you in "trouble" (in ASCII, within the
post, not as a screenshot).

- V

Dear Sir,

Thank You very much for your replies. I attached an ASCII file with oracle tables existing on new created geodatabase.
I do not know where I'm wrong!

Thank you very much,
Anisim Desia

fields_ascii.txt.zip

What I want it to look like.PNG

VinceAngelo

Please provide the list of tables that have you in "trouble" (in ASCII, within the
post, not as a screenshot).

- V

AnisimDesya

Hi,
I try to create a new <Tablespace> and a new <User> and run <Create Enterprise Geodatabase> Tool, but this trouble still exist.
Oracle tables appear on this new connection.

I do not know where I'm wrong? For me still a big trouble!

Thank you very much,
Anisim Desia

VinceAngelo

The SDE user should own all the tables specified in the documentation to implement
the geodatabase. The ArcSDE API hides these tables as well as most system tables
to reduce confusion, but other packages in your install may create nominal tables
to which PUBLIC access has been granted. Seeing these isn't "big trouble".

You shouldn't ever use the SDE user for data creation; instead create one or more
tablespaces and one or more users with access to those tablespaces for geo data
management.

- V

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.