create_tablespace.sql

来自「使用短信猫可以实现短信的群发」· SQL 代码 · 共 29 行

declare
	i number(1);
	j number(1);
begin
	select count(*) into i from user_tablespaces where upper(TABLESPACE_NAME)='SMS';
	select count(*) into j from user_tablespaces where upper(TABLESPACE_NAME)='TS_TEMP';
	if i>0 then
		EXECUTE IMMEDIATE 'drop tablespace SMS including contents and datafiles';
	end if;
	
	if j>0 then
		execute immediate 'drop tablespace TS_TEMP including contents and datafiles';
	end if;
end;
/

commit;


create tablespace SMS
	datafile '&1\SMS.ora' size 5m
	autoextend on next 5m maxsize 100m;
	
create temporary tablespace TS_TEMP 
	tempfile '&1\TS_TEMP.ora' size 5m
	autoextend on next 5m maxsize 100m;
commit;