--建立表空间和用户的步骤:
--以dba身份连接sqlplus:
sqlplus sys/password@orcl as sysdba
--建立用户并使用默认的表空间:
create user wfw identified by wfw DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
--授予角色:
grant connect to wfw;
grant resource to wfw;
grant dba to wfw;
--授权:
grant create session to wfw ;
grant create table to wfw ;
grant create any table to wfw ;
grant create any procedure to wfw ;
grant create any sequence to wfw ;
grant create any view to wfw ;
grant create any trigger to wfw ;
--创建表空间:
--临时表空间:
create temporary tablespace oaisdata_temp
tempfile 'e:\develop\oracle11g\oaisdata_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建表空间
create tablespace oaisdata
logging
datafile 'e:\develop\oracle11g\oaisdata.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--删除用户:
drop user wfw cascade;