常见表空间操作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=用户名