常见表空间操作sql语句

1--增加表空间语句 alter tablespace issp_rygk add datafile 'data/orcl/datafile/issp_rygk01.dbf' size 2048M autoextend off; 2--查看表空间剩余 select tablespace_name,count(1) as extends,round(SUM(bytes)/1024/1024,2) as mb,SUM(blocks) as blocks from dba_free_space where tablespace_name like 'issp%' group by tablespace_name order by tablespace_name; 3--查看表空间是否设置自动增长 select file_name,tablespace_name,autoextensible from dba_data_files; 4--设置表空间自动增长(每次增长2g空间) alter database datafile '+DATA/orcl/datafile/issp_wifiinfo1.dbf' autoextend on next 2048M; 5--oracle导出数据库命令 exp 用户名/密码@orcl_数据库服务器ip地址 file=E:\xxx.dmp owner=用户名