查询表空间
select file_name from dba_data_files;
创建表空间时,注意放的位置
创建临时表空间
create temporary tablespace USR_****_TEMP
tempfile '\oradata1\****\****_TEMP.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
创建数据表空间
create tablespace USR_****_DATA
logging
datafile '\oradata1\****\USR_****_DATA.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;