25/02/2013

Oracle delete purge object

In Oracle, when you delete a table with the DROP TABLE statement (or another object for that matter), it's not definitevly deleted as it goes instead into the recycle bin. This can be good as you may recover your objects with the FLASHBACK command but can also cause issues if other objects depend on or refer to the deleted one.

To permanently delete the object, you can either disable the recycle bin or use the PURGE command along with you DROP statement.

No comments:

Post a Comment

With great power comes great responsibility