select 'alter database datafile '||''''||name||''''||'resize 100m;' from v$datafile;
输出结果为
alter database datafile '/u01/app/oracle/oradata/PROD1/system01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/sysaux01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/undotbs01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/users01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/example01.dbf'resize 100m;
输出结果为
alter database datafile '/u01/app/oracle/oradata/PROD1/system01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/sysaux01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/undotbs01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/users01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/example01.dbf'resize 100m;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29135257/viewspace-2077686/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
