drop_schema_objects.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : Drop all schema objects
-- Call Syntax  : @drop_schema_objects.sql
-- Last Modified: 17/03/2015
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT 'DROP ' ||object_type ||' ' ||owner ||'.' ||object_name ||';'
FROM dba_objects WHERE owner='&owner'
AND object_type <> 'DATABASE LINK';