oracle创空间用户及授权查看权限.docVIP

Oracle 创建表空间、创建用户以及授权、查看权限 一、创建临时表空间 # sqlplus / as sysdba; sql CREATE TEMPORARY TABLESPACE test_temp TEMPFILE /opt/oradata/test_temp.dbf SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; 二、创建用户表空间 sql CREATE TABLESPACE test_data LOGGING DATAFILE /opt/oradata/test_data.dbf SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; sql select tablespace_name,block_size,extent_management,segment_space_manag