创建表空间以及用户权限

create tablespace test_data
logging
datafile 'E:\data\test_data01.dbf'
size 32M
autoextend on
next 32M maxsize 2048M
EXTENT MANAGEMENT LOCAL;
------------
create temporary tablespace test_temp
logging
tempfile 'E:\data\test_temp01.dbf'
size 32M
AUTOEXTEND on
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
-----------
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'E:\data\test_temp01.dbf '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
----------
CREATE USER testmview IDENTIFIED BY testmview
DEFAULT TABLESPACE TEST_DATA
TEMPORARY TABLESPACE TEST_TEMP;
-----
GRANT dba TO testmview;