The Oracle equivalent of SHIFT+DELETE SQL

 


-- *** WARNING ***
-- this script will clear down your user's recyclebin
-- be sure you don't want to recover anything in there before running this!
-- *** WARNING OVER ***

create table goes_to_recyclebin_unless_i ( x integer);

-- no purging, so it hangs around
drop table goes_to_recyclebin_unless_i;

-- as you can see
select original_name, droptime from recyclebin;

-- clear down the bin
purge recyclebin;

select original_name, droptime from recyclebin;

--try again, this time purging everything
create table goes_to_recyclebin_unless_i ( x integer);

drop table goes_to_recyclebin_unless_i purge;

select original_name, droptime from recyclebin;

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)