unclerayray

Those that can, do. Those that can’t, complain.
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

Today I learnt

Posted on 2015-05-22 18:13  unclerayray  阅读(98)  评论(0)    收藏  举报

2015-May-22

In Oracle database, dropping a table don't free up the space directly. You'll need to disabled the DB recycle bin. So whenever we drop something, it's purged automatically to free the space.

 

 

http://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm

 

And another minor suggestion about searching Oracle doc on Google. Add 112 to show 11g release 2 doc on top.