PURGE¶
In Oracle, the DROP TABLE statement moves a table to the recycle bin, allowing for potential recovery. In contrast, the PURGE statement permanently deletes a table or index from the recycle bin, releasing all associated space. It can also empty the entire recycle bin or permanently remove specific contents from a deleted tablespace.
After migration using Oracle syntax, the query does not include PURGE.
The following examples illustrate the syntax changes for PURGE before and after migration.
Pre-migration¶
Figure 1 Input: statement containing PURGE¶
Post-migration¶
Figure 2 Output: statement without PURGE¶