17,377
社区成员
发帖
与我相关
我的任务
分享
-- 动态生成吧
SQL> with m as (
2 select 'TS01' name from dual union
3 select 'TS02' from dual union
4 select 'AK' from dual
5 )
6 select 'create tablespace ' || name || ' datafile ''c:\' || name || '.dbf'' size 100m;' s
7 from m
8 /
S
--------------------------------------------------------
create tablespace AK datafile 'c:\AK.dbf' size 100m;
create tablespace TS01 datafile 'c:\TS01.dbf' size 100m;
create tablespace TS02 datafile 'c:\TS02.dbf' size 100m;