Creating the sde user and tablespace in Oracle

After you install Oracle, you must create a user named sde, in whose schema the geodatabase will be stored. You should also create a default tablespace for this user.

In most cases, this user is a database-authenticated user. The instructions in this topic describe creating this user and tablespace. If you want to use an operating system (OS) authenticated user, see your Oracle documentation for instructions on setting up an OS-authenticated account.

If your Oracle database and ArcSDE installation are on a Windows server, you do not need to do this step using SQL; the Post Installation wizard does it for you based on information you provide.

Tip:

There is a script (createsdeoracle.sql) installed with ArcSDE for Oracle in SDEHOME > tools > oracle that can be altered and used to create an sde tablespace and user, and grant the sde user permissions to either create a geodatabase or upgrade it.

Follow these steps to create the sde user and default tablespace manually.

Steps:

1. Log in to SQL*Plus as the system user.
2. Create a tablespace for the sde user.

   In this example, a tablespace named sde in an Oracle database on a UNIX server is created.

   CREATE TABLESPACE sde
   DATAFILE '/oragis/sde.dbf' size 400M
   EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K;

3. Create the sde database user and assign default and temporary tablespaces to it.

   In this example, the sde user's password is ruda.bega, the default tablespace is sde, and the temporary tablespace is temp.

   CREATE USER sde IDENTIFIED BY ruda.bega
   DEFAULT TABLESPACE sde TEMPORARY TABLESPACE temp;

Now that the sde user exists, assign the user permissions to create the geodatabase.