创建表空间以及用户权限

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;