Breaking News: Grepper is joining You.com. Read the official announcement!

delete all table oracle

Add Answer

Sleepy Squirrel answered on January 23, 2021 Popularity 10/10 Helpfulness 6/10

answer delete all table oracle

related delete rows table oracle

related oracle sql drop table purge

related Delete table in Oracle

delete all table oracle

Comment

BEGIN
   FOR cur_rec IN (SELECT object_name, object_type
                   FROM user_objects
                   WHERE object_type IN
                             ('TABLE',
                              'VIEW',
                              'MATERIALIZED 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;
   FOR cur_rec IN (SELECT * 
                   FROM all_synonyms 
                   WHERE table_owner IN (SELECT USER FROM dual))
   LOOP
      BEGIN
         EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM ' || cur_rec.synonym_name;
      END;
   END LOOP;
END;
/

Popularity 10/10 Helpfulness 6/10 Language sql

Source: stackoverflow.com

Tags: drop oracle sql

Link to this answer
Share Copy Link

Contributed on Aug 10 2021

Sleepy Squirrel

0 Answers Avg Quality 2/10

Closely Related Answers

delete rows table oracle

Comment

DELETE FROM my_table;		-- all rows, commit needed
TRUNCATE TABLE my_table;	-- all rows, no possible rollback
DELETE FROM my_table WHERE my_id = 12345;
DELETE FROM my_table WHERE my_id IN (SELECT id2 FROM my_table2);
COMMIT;		-- don't forget it...

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: oracle or

Link to this answer
Share Copy Link

Contributed on May 15 2021

VasteMonde

0 Answers Avg Quality 2/10

oracle sql drop table purge

Comment

DROP TABLE customers PURGE;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: drop-table d

Link to this answer
Share Copy Link

Contributed on Jan 23 2021

VasteMonde

0 Answers Avg Quality 2/10

Delete table in Oracle

Comment

DROP TABLE C##BOBSIE.FakeInnerContainers

Popularity 8/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: oracle sql

Link to this answer
Share Copy Link

Contributed on Mar 16 2023

Mahesh Kumar Yadav

0 Answers Avg Quality 2/10

delete all table oracle

Contents

More Related Answers

delete all table oracle

Closely Related Answers

delete rows table oracle

oracle sql drop table purge

Delete table in Oracle

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.