修改数据文件大小

 select file#,name,f.* from v$datafile f where f.name like ‘/home/oracledb/dbf/DATA_CIS_TEST%‘

--查出最大数据块  -- 4192640
select max(block_id) from dba_extents where file_id=45;

--查询数据块的大小，单位是 byte  --8192 byte= 8kb
select value from v$parameter where name=‘db_block_size‘  

--32755 MB
select 4192640 * 8 / 1024 from dual;

alter database datafile ‘/home/oracledb/dbf/DATA_CIS_TEST.dbf‘ RESIZE 33000M;