/*第1步:创建临时表空间 */
create temporary tablespace psdb_temp
tempfile ' E:\OracleData\PSDB\psdb_temp.dbf'
size 50m
autoextend on
next 50m
extent management local;
--创建表空间
create tablespace psdbspace
datafile 'E:\OracleData\PSDB\psdb.dbf'
size 1024M AutoExtend On Next 100M
extent management local
segment space management auto
--创建用户
create user psdba identified by psdb
default tablespace psdbspace
temporary tablespace psdb_temp;
--授权
grant connect,resource to psdba ;
grant create view to psdba;--视图
grant create Snapshot to psdba;--物化视图