oracle创建表空间

查询表空间数据文件保存位置

select tablespace_name,file_id,bytes,file_name from dba_data_files;

create tablespace tp_qywsbspt  

datafile '/u01/app/oracle/oradata/qywsbs/qywsbspt01.dbf' size 800M   
autoextend on  
next 50M  
maxsize unlimited  

create temporary tablespace tp_qywsbspt_tmp 
tempfile '/u01/app/oracle/oradata/qywsbs/qywsbspttmp01.dbf' 
size 800m 
autoextend on 

next 50m maxsize unlimited 

表空间增加文件

alter tablespace tp_qywsbspt add

datafile '/u01/app/oracle/oradata/qywsbs/qywsbspt02.dbf' size 800M

• autoextend on next 50M  
• maxsize 1000M;