oracle数据库建立表空间、用户、并授权

--表空间CREATE TABLESPACE RMIP_PROCESSDBLOGGINGDATAFILE '/u01/app/oracle/oradata/rmip/RMIP_PROCESSDB.DBF'SIZE 32MAUTOEXTEND ONNEXT 32M MAXSIZE 2096MEXTENT MANAGEMENT LOCAL;--临时表空间CREATE TABLESPACE RMIP_PROCESSDB_TEMPLOGGINGDATAFILE '/u01/app/oracle/oradata/rmip/RMIP_PROCESSDB_TEMP.DBF'SIZE 32MAUTOEXTEND ONNEXT 32M MAXSIZE 2096MEXTENT MANAGEMENT LOCAL;--建用户分配表空间和临时表空间create user rxdev identified by rxdev123 default TABLESPACE RMIP_PROCESSDB temporary TABLESPACE RMIP_PROCESSDB_TEMP;--分配权限grant connect,resource,dba to rxdev;grant unlimited tablespace to rxdev;