oracle创建用户和表空间

创建用户 

create user V7HQS
  identified by "password"
  default tablespace USERS
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges
grant aq_administrator_role to V7HQS with admin option;
grant connect to V7HQS with admin option;
grant dba to V7HQS with admin option;
grant resource to V7HQS with admin option;
-- Grant/Revoke system privileges
grant create any table to V7HQS with admin option;
grant unlimited tablespace to V7HQS with admin option;

connect v7hqs/rezin@orcl
/

 

创建表空间

CREATE TABLESPACE TSDIC
DATAFILE 'e:/TSDIC.dbf' size 200M
EXTENT MANAGEMENT local;