需求:
申请一套Oracle 11g数据库(opas),字符集(gbk),账号(fid_opas),表空间(opas_data,opas_data)
相关指令:
# 前提:前提:前提:===>>> 数据库已安装完成
# echo $ORACLE_SID (查看实例名,因为一套库中即有gbk、也有utf8,实例名是已字符集开头)
# export $ORACLE_SID=gbkdb (若已经是gbk开头的无需执行这一步)
# sqlplus / as sysdba
SQL> select username, created from dba_users where username = 'FID_OPAS'; # 查看该用户是否已存在
SQL> create tablespace opas_data datafile size 10G;
SQL> create tablespace opas_index datafile size 10G;
SQL> create user fid_opas identified by pwd_opas default tablespace opas_data;
SQL> grant connect, resource to fid_opas;
SQL> revoke unlimited tablespace from fid_opas;
SQL> alter user fid_opas quota unlimited on opas_data;
SQL> alter user fid_opas quota unlimited on opas_index;
## 验证
SQL> conn fid_opas/pwd_opas