Oracle中的删除和删除清除之间的区别 [英] Difference Between Drop And Drop Purge In Oracle

问题描述

我正在使用Oracle数据库，并且对Drop and Purge Commands有点困惑.实际上，对于我来说，两者都做同样的事情.从数据库中删除带有模式的表.两者的主要区别是什么?

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表名；
2. 删除表表名清除；

推荐答案

通常，如果删除了表，则将该表移入回收站(从Oracle 10g开始).但是，如果还指定了purge修饰符，则无法从数据库中删除(完全)删除该表.

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.

这篇关于Oracle中的删除和删除清除之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！