set linesize 200
col tablespace_name format a8
col file_name format a45
select tablespace_name, file_id, file_name, bytes/1024/1024 size_m, AUTOEXTENSIBLE, INCREMENT_BY*1024/8 incre_MB
from dba_data_files
where tablespace_name=‘TESTTBS’
/
—
alter database datafile ‘/chhs32/chpwtst4/oradata/EDIDATATS_26.dbf’ resize 100M ;
or alter database datafile 310 resize 100M ;
alter tablespace TESTTBS read only ;
alter database datafile 310 offline ;
host mv /chhs32/chpwtst4/oradata/EDIDATATS_26.dbf /chhs32/chpwtst4/oradata/DIAMOND_128.dbf
alter database rename file ‘/chhs32/chpwtst4/oradata/EDIDATATS_26.dbf’ to ‘/chhs32/chpwtst4/oradata/DIAMOND_128.dbf’;
alter database datafile 310 online ;
alter tablespace TESTTBS read write
近期评论