Answers for "oracle recycle bin disable"

SQL
6

oracle disable recycle bin

-- Drop and recovery
DROP TABLE books;
FLASHBACK TABLE books TO BEFORE DROP;
DROP TABLE books PURGE;			-- won't go in recycle bin
-- Contents of recycle bin
SELECT OWNER, ORIGINAL_NAME, OPERATION, TYPE, TS_NAME, DROPTIME, SPACE / 1e3
FROM DBA_RECYCLEBIN;
-- Purge
PURGE RECYCLEBIN;
PURGE DBA_RECYCLEBIN;
PURGE TABLE my_table;
-- Disable / enable recycle bin
ALTER SYSTEM SET DBA_RECYCLEBIN = off;   	-- on
ALTER SESSION SET DBA_RECYCLEBIN = off;   	-- on
Posted by: Guest on October-19-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language