gprocino

CREATE DATABASE USER TOOL and tablespace best pratice

Discussion created by gprocino on Jan 29, 2014
Latest reply on Jan 30, 2014 by mousaem
Hi,
I have setting up geodatabase on oracle11gR2.
I created geodatabase within a tablespace named SDE_TBS (the default name for sde user).

Now, I am creating new users using "create database user tool" and I can specify a tablespace name.

Are there best pratices for tablespace to use?

Which tablespace should i use for each new user?
- Oracle default tablespace
- SDE_TBS (same SDE USER)
- a new tablespace (<newusername>_TBS)

Thanks a lot
Giuseppe P.

Outcomes