查看当前目录的总大小:
du -sh
查看表空间大小
select sum(blocks) "Total Blocks",sum(bytes) "Total Size" from dba_extents where owner='PDJ' and tablespace_name='PDJ_DATA';
查看表空间和文件名关系
select tablespace_name, file_name,file_id from dba_data_files;
缩小文件
alter database datafile '/home/oracle/userdata/pdj_data.dbf' resize 10M
du -sh
查看表空间大小
select sum(blocks) "Total Blocks",sum(bytes) "Total Size" from dba_extents where owner='PDJ' and tablespace_name='PDJ_DATA';
查看表空间和文件名关系
select tablespace_name, file_name,file_id from dba_data_files;
缩小文件
alter database datafile '/home/oracle/userdata/pdj_data.dbf' resize 10M