Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- FOR cur_rec IN (SELECT object_name, object_type
- FROM user_objects
- WHERE object_type IN
- ('TABLE',
- 'VIEW',
- 'PACKAGE',
- 'PROCEDURE',
- 'FUNCTION',
- 'SEQUENCE',
- 'SYNONYM',
- 'PACKAGE BODY'
- ))
- LOOP
- BEGIN
- IF cur_rec.object_type = 'TABLE'
- THEN
- EXECUTE IMMEDIATE 'DROP '
- || cur_rec.object_type
- || ' "'
- || cur_rec.object_name
- || '" CASCADE CONSTRAINTS';
- ELSE
- EXECUTE IMMEDIATE 'DROP '
- || cur_rec.object_type
- || ' "'
- || cur_rec.object_name
- || '"';
- END IF;
- EXCEPTION
- WHEN OTHERS
- THEN
- DBMS_OUTPUT.put_line ( 'FAILED: DROP '
- || cur_rec.object_type
- || ' "'
- || cur_rec.object_name
- || '"'
- );
- END;
- END LOOP;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment