2019-12-27

/*分为四步 /
/第1步：创建临时表空间 */
create temporary tablespace HZKJ_ORA_TEMP
tempfile 'F:\app\Administrator\oradata\orcll\HZKJ_ORA_TEMP.dbf'
size 500m
autoextend on
next 500m maxsize 20480m
extent management local;

/*第2步：创建数据表空间 */
create tablespace HZKJ_ORA
logging
datafile 'F:\app\Administrator\oradata\orcll\HZKJ_ORA.dbf'
size 500m
autoextend on
next 500m maxsize 20480m
extent management local;

/*第3步：创建用户并指定表空间 */
create user WHDX_ZJK identified by zhangrun default tablespace WHDX_ZJK temporary tablespace WHDX_ZJK_TEMP;

/*第4步：给用户授予权限 */
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
CONNECT,RESOURCE,CREATE SESSION TO scott;