Search code examples
sqloracleoracle10g

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;

Solution

  • 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.