oracle创建用户

--创建数据表空间
create tablespace test_data
logging
datafile 'E:\oracle\product\10.2.\oradata\testserver\test_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
--创建用户并指定表空间
create user xuebao_test identified by xuebao_test
default tablespace test_data
--给用户授予权限
grant connect,resource to xuebao_test;

--查询表空间及文件
select * from sys.dba_data_files;
select * from sys.dba_tablespaces;