Oracle 删除表的用法及说明

(1) Drop Table Tablename:

Without purge, the table can be in the RECYCLEBIN or USER_RECYCLEBIN; which can be restored using the command FLASHBACK. This is similar to files we delete in our windows desktop, which move to the recycle bin, and can be restored back.

(2) Drop Table Tablename Purge:

If Drop is given along with Purge, its tablespace is released and cannot be restored. (Like Shift+Delete in desktop)

SQL>drop table table_name;

This command deletes the table named table_name, but internally it is moved to recycle bin of oracle (which is just similar to deleting any file/folder using Delete key on windows os).

Benefits:

1. We will be able to restore the above deleted table if required.

Drawbacks:

1. Still occupies some amount of memory.

SQL>drop table table_name purge;

This command deletes the table table_name completely from the database (which is similar to deleting any file/folder using Shift + Delete key on windows OS).

-- 刘轶鹤