oracle 创建表用户/空间/临时表空间设置用户默认表空间 为用户授权操作实例

create tablespace jif datafile 'D:\MyOracleDB\jiftablespace.dbf' size 200m reuse autoextend on next 10m;

create temporary tablespace jiftemp   tempfile 'd:/oracle/oradata/zwt/jiftemp01.ora' size 100M; 

create user jif identified by jif;

alter user jif identified by jif   default tablespace jif temporary tablespace jiftemp;

grant dba to jif;