How to bulk delete temporary table, as the chart, the oracle database

CodePudding user response:

Right-click the drop PLSQL batch selected

CodePudding user response:

The begin
For the TAB (in
Select the 'drop table' | | table_name | | 'purge' as SQL from user_tables where table_name like '% TEMP %'
) loop
The execute immediate TAB. SQL;
end loop;
end;

Model queries, can use multiple; See how will you want to delete the table, and cannot be deleted you don't want to delete the table;
This script, the most useful is to clear all the tables,

CodePudding user response:

Use dba_tables data field view to generate a drop script,

CodePudding user response:

reference minsic78 reply: 3/f

view dba_tables data field is used to generate the drop script,

Graphical tools are basic right batch delete functions, and there is no need for so long,