Shulou(Shulou.com)06/01 Report--

Drop table t; differs from drop table t purge in that the latter does not put into the Recycle after the table is deleted, while the former is put into the recyle.

For example:

1. Create table a (id,number)

2. Insert into a values (1); commit

3. Select * from a

Id

one

4 、 drop table a

5 、 show recyclebin

You will see that the table is in the Recycle Bin, and then you can use flashback for recovery.

Such as: flashback table a to before drop

At this time, the table has been restored from the Recycle Bin.

If the above drop action is used

Drop table a purge, this means that no one has entered the recyle, so you cannot use flashback for recovery.

This is rarely used by people, one is to type one more word command, and the other is that it will be difficult to restore if deleted.

In fact, under normal circumstances, when oracle deletes objects such as tables, it is first said that these objects are put into the Recycle Bin, how much space should be occupied or how much space will be occupied, and know whether they are occupied or not.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.