动态创建表

create user testa
identified by testa
default tablespace users
quota unlimited on users;

grant resource,create session to testa;

conn testa/testa;

create table aa (id int); ----当前用户testa下，此句可以成功

create or replace procedure sp_1 --当前用户testa下，创建SP,来动态创建表
as
ssql varchar2(1000);
begin
begin
ssql:='create table TMP_A (id int)';
execute immediate ssql;
exception
when others then
RAISE;
end;
end sp_1;
/

exec sp_1; --仍在当前用户testa下执行