1、先登录服务器后,切换到oracle用户状态下: su oracle
2、进入sqlplus,命令:sqlplus / as sysdba
3,创建用户表空间:
CREATE TABLESPACE HYGEIA datafile '/ora11g/app/oracle/oradata/orcl/zyq01.dbf' size 600M autoextend on next 50m maxsize unlimited;
4.创建用户,指定密码和上边创建的用户表空间
create user ecard_test3 identified by ecard$123 default tablespace HYGEIA;
5.赋予权限
grant connect,resource,dba to ecard_test3;
grant create any synonym,create any view,debug any procedure,unlimited tablespace to ecard_test3;