테이블 프로시저 시퀀스 인덱스 뷰 모두 삭제

SELECT  'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'

  FROM    user_objects

WHERE   object_type = 'TABLE';

SELECT  'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'

  FROM    user_objects

WHERE   object_type = 'PROCEDURE';

SELECT  'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'

  FROM    user_objects

WHERE   object_type = 'SEQUENCE';

SELECT  'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'

  FROM    user_objects

WHERE   object_type = 'INDEX';

SELECT  'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'

  FROM    user_objects

WHERE   object_type = 'VIEW';