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