POST
|
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
07-01-2014
01:16 PM
|
0
|
0
|
290
|
POST
|
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
07-01-2014
12:59 PM
|
0
|
0
|
290
|
POST
|
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
06-30-2014
12:32 PM
|
0
|
0
|
786
|
POST
|
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
06-30-2014
12:28 PM
|
0
|
0
|
786
|
POST
|
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
06-30-2014
11:54 AM
|
0
|
0
|
786
|
POST
|
This thread http://forums.arcgis.com/threads/8782-multiple-geodatabase-at-oracle
... View more
06-30-2014
11:29 AM
|
0
|
0
|
786
|
POST
|
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
06-30-2014
11:24 AM
|
0
|
0
|
786
|
POST
|
Hi! I've tried to Enable Geodatabase to existing user, but the ArcGIS show me: "Executing: EnableEnterpriseGeodatabase "Database Connections\RNCET - GIS2.sde" "C:\Program Files (x86)\ESRI\License10.2\sysgen\keycodes" Start Time: Mon Jun 30 14:48:38 2014 WARNING 000152: Geodatabase instance already exists. Succeeded at Mon Jun 30 14:48:38 2014 (Elapsed Time: 0.14 seconds)" I have already two users SDE(SYSTEM TABLES) and GIS(FEATURES), but I want to use a MULTIGEODATABASE with the same oracle instance. Configuration: ArcGIS 10.2 64 bits, Windows 7 64 bits, Oracle 11g R2.
... View more
06-30-2014
09:52 AM
|
0
|
15
|
5584
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|