create tablespace mytbs datafile '/orcl/mytbs0001.dbf' size 512k;
drop tablespace mytbs including contents and datafiles;
select file_id,relative_fno,file_name,tablespace_name from dba_data_files where tablespace_name='MYTBS';
create or replace procedure p1
as
begin
execute immediate 'create tablespace mytbs datafile '||chr(39)||'/orcl/mytbs0001.dbf'||chr(39)||' size 512k';
for i in 2..1023 loop
execute immediate 'alter tablespace mytbs add datafile '||chr(39)||'/orcl/mytbs'||lpad(i,4,0)||'.dbf'||chr(39)||' size 512k';
end loop;
end;
/
SYS@orcl> exec p1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28675539/viewspace-1146293/ ，如需转载，请注明出处，否则将追究法律责任。
