Deleting all objects user / schema


DECLARE
  CURSOR CC IS
  SELECT * FROM ALL_OBJECTS WHERE OWNER='ANAR';  ----- My user
BEGIN

      FOR I IN 1..5 LOOP 
            FOR II IN CC LOOP
           BEGIN
            EXECUTE IMMEDIATE 'DROP '||II.OBJECT_TYPE||' '||II.OWNER||'.'||II.OBJECT_NAME;
              DBMS_OUTPUT.PUT_LINE(II.OBJECT_TYPE||' '||II.OWNER||'.'||II.OBJECT_NAME);
          
              EXCEPTION WHEN OTHERS THEN
                    NULL;
           END;
         END LOOP;
      END LOOP;
END;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: