topic Re: ArcSDE/new Geodatabase is not empty in Data Management Questions

ArcSDE/new Geodatabase is not empty

AnisimDesya — Thu, 31 Jan 2013 10:25:28 GMT

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

Re: ArcSDE/new Geodatabase is not empty

VinceAngelo — Thu, 31 Jan 2013 12:34:40 GMT

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

Re: ArcSDE/new Geodatabase is not empty

AnisimDesya — Fri, 01 Feb 2013 11:28:35 GMT

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

Re: ArcSDE/new Geodatabase is not empty

VinceAngelo — Fri, 01 Feb 2013 22:01:20 GMT

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

- V

Re: ArcSDE/new Geodatabase is not empty

AnisimDesya — Mon, 04 Feb 2013 03:22:22 GMT

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

Re: ArcSDE/new Geodatabase is not empty

VinceAngelo — Mon, 04 Feb 2013 11:55:37 GMT

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