Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Difference Between Drop And Drop Purge In Oracle

I am using Oracle Database and I am a bit confused about Drop and Purge Commands. In fact for me both does the same thing. Removes the table with schema from database. What is the main difference between these two?

  1. Drop Table Tablename;
  2. Drop Table Tablename Purge;

1 Answers

Normally, a table is moved into the recycle bin (as of Oracle 10g), if it is dropped. However, if the purge modifier is specified as well, the table is unrecoverably (entirely) dropped from the database.

like image 137
Randy Avatar answered Sep 07 '25 21:09

Randy