create or replace procedure p_mhxtemp is
begin
execute immediate 'DROP TABLE reportRecord ';
execute immediate 'CREATE GLOBAL TEMPORARY TABLE reportRecord ON COMMIT PRESERVE ROWS AS SELECT * FROM T_BASE_ENTERPRISES ';
end p_mhxtemp;执行时候会报
attempt to create,alter or drop an index on temporary table already in use
要怎么处理
begin
execute immediate 'DROP TABLE reportRecord ';
execute immediate 'CREATE GLOBAL TEMPORARY TABLE reportRecord ON COMMIT PRESERVE ROWS AS SELECT * FROM T_BASE_ENTERPRISES ';
end p_mhxtemp;执行时候会报
attempt to create,alter or drop an index on temporary table already in use
要怎么处理
execute immediate 'DROP TABLE reportRecord ';这句会出错的
truncate table reportRecord ;再使用drop table reportRecord ;
..........后面的你已经知道了