【创建表空间】
CREATE TABLESPACE testspace
DATAFILE
'F:\app\administrator\oradata\mydb\testspace.dbf' size 1024k REUSE
AUTOEXTEND ON NEXT 1024k
MAXSIZE 200M
ONLINE
PERMANENT;
【创建表空间用户】
CREATE USER testusr IDENTIFIED BY testcode DEFAULT TABLESPACE testspace;
GRANT GLOBAL QUERY REWRITE, UNLIMITED TABLESPACE,CONNECT, RESOURCE, CREATE MATERIALIZED VIEW TO testusr ;
【查看表空间列表】
SQL> SELECT tablespace_name,logging,status FROM dba_tablespaces;
【查看表空间对应数据文件】
SQL> SELECT file_name,tablespace_name,status FROM dba_data_files WHERE tablespace_name = 'TESTSPACE';