Oralce数据库表空间创建、用户创建、授权
/*第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;--物化视图
?