一个创建用户的脚本
DEFINE cre_user=admin
DEFINE cre_user_pwd=admin
DEFINE def_tbsp=admin_data
DEFINE idx_tbsp=admin_index
DEFINE def_temp_tbsp=temp
CREATE TABLESPACE admin_data
datafile 'u01/app/oracle/oradata/orcl/admin_data.dbf'
size 100M
extent management local --使用位图本地管理表空间
uniform size 128k --为每个区分配相同大小空间128k
segment space management auto;
CREATE TABLESPACE admin_index
datafile 'u01/app/oracle/oradata/orcl/admin_index.dbf'
size 100M
extent management local --使用位图本地管理表空间
uniform size 128k --为每个区分配相同大小空间128k
segment space management auto;
CREATE USER &&cre_user IDENTIFIED BY &&cre_user_pwd
DEFAULT TABLESPACE &&def_tbsp
TEMPORARY TABLESPACE &&def_temp_tbsp;
GRANT CREATE SESSION TO &&cre_user;
GRANT CREATE TABLE TO &&cre_table;
ALTER USER &&cre_user QUOTA UNLIMITED ON &&def_tbsp;
ALTER USER &&cre_user QUOTA UNLIMITED ON &&idx_tbsp;