DROP or TRUNCATE all tables from a database

To DROP or TRUNCATE all the tables of a database




SET SERVEROUTPUT ON 

BEGIN
FOR tables IN (SELECT table_name as tname FROM user_tables)
LOOP
DBMS_OUTPUT.PUT_LINE('DROP TABLE ' || tables.tname || ' CASCADE CONSTRAINTS PURGE;')
EXECUTE IMMEDIATE('DROP TABLE ' || tables.tname || ' CASCADE CONSTRAINTS PURGE;');
END LOOP;
END;
/



SET SERVEROUTPUT ON 

BEGIN
FOR tables IN (SELECT table_name as tname FROM user_tables)
LOOP
DBMS_OUTPUT.PUT_LINE('TRUNCATE TABLE ' || tables.tname  || ';')
EXECUTE IMMEDIATE('TRUNCATE TABLE ' || tables.tname || ' ;');
END LOOP;
END;
/