Latest Contributions by MarioRocha

I've created in excess of 10,000 geodatabase instances in the past 18 years.  I've never had difficulty creating multiple users in a single instance, then creating and registering tables with the geodatabase as those users.  "Enable Enterprise Geodatabase" only happens once, and the rest is just basic administration.  If users can't create tables, that's a database administration issue (missing required permissions). - V But the other users has the same SDE privilegies, Can you explain the step-to-step to do it? ... View more

Thank you for your attention! Only SDE user-schem has the system tables, and the best pratice says to separate two instances, ok! But if I don't have another option, Can I do a SDE  like master administrator scheme and a GIS with GDB,COLUMN_REGISTRY,TABLE_REGISTRY tables? If answer yes, so how can I do it? ... View more

Thank's! But I don't have another way, I have only one instance and I don't have DBA(SYS) privilegies, so I have to solve it anyway! ... View more

I'm not DBA, so I don't have all privilegies. I created SDE and GIS users in Oracle, after I Enable Enterprise Geodatabase to SDE Connection created. I understood that I can only one master geodatabase, but why doesn't work GDB tables in another user in the same instance? ... View more

As noted in the referenced thread, you cannot create two independent "master" geodatabases in the same Oracle 11g instance.  You could just use two different users in a single instance, or you could use the same owner name in two Oracle instances.  It would be unwise to use the same tablespace(s) in the former configuration. - V "You could just use two different users in a single instance" So I have tried it, but no sucess!!! When I try on the second user connection to "Enable Enterprise Geodatabase", it doesn't work! I using sdo_geometry type, isn't it problem??? ... View more

This thread http://forums.arcgis.com/threads/8782-multiple-geodatabase-at-oracle ... View more

Sorry guys! So let's go! I need to create a scenario using "Production and Publication Geodatabases", but only one instance Oracle 11g R2, in the same tablespace. Following steps below: 1) In Oracle, I created the SDE user with privileges for CRATING an SDE master geodatabase. In ArcGIS > ArcCatalog > Data Management > Enable Enterprise Geodatabase > SDE Connection;(OK) 2) In Oracle, I created the GIS user with privileges for UPGRADING an SDE master geodatabase. (OK) 3) In Oracle, I created the SDE2 user with privileges for CRATING an SDE master geodatabase. In ArcGIS > ArcCatalog > Data Management > Enable Enterprise Geodatabase > SDE Connection;(ERROR) Why the third step doesn't work? ... View more