Richard C richard087

richard087 / purge_schema.sql

Last active October 1, 2020 01:16

	set echo off
	set verify off
	set serveroutput on size 100000

	-- Hosted at http://lastinfinitetentacle.blogspot.com/2012/03/empty-oracle-schema-leave-empty-schema.html

	-- Disable all contraints
	BEGIN
	FOR c IN
	(SELECT c.owner, c.table_name, c.constraint_name