利用存储过程对一个表空间批量添加数据文件

create or replace procedure  proc_t1 as
col_id varchar(255);
begin
for i in 2..80 loop
col_id:='test'||i;
execute immediate 'alter tablespace test  add datafile '||''''||col_id ||'.dbf'||''''||' size 64K ';
end loop;
commit;
end;

 

转载于:https://www.cnblogs.com/wangqianqiannb/p/9177956.html