forked from docs/doc-exports
luhuayi
a5e3903f6b
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
3.1 KiB
3.1 KiB
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
Parent topic: Schema Objects