-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- 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';