PL/SQL块或者存储过程中不能执行DDL，可以使用动态SQL

-- 创建临时表
v_dynamic_sql :=
'Create global temporary table '
|| 'TEST'
|| ' on commit preserve rows as select * from '
|| 'ALL_OBJECTS Where 1= 2 ';
EXECUTE IMMEDIATE v_dynamic_sql;