Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    17

    Unanswered: dropping tables and freeing space on tablesaces

    oracle 10g rel2, operating system AIX v5

    i have noticed that when users drop tables there is a another table that is created which starts with bin followed by funny characters when i try to drop them they are not getting dropped.
    how best do i do this. another thing what is the best way to free space on tablespaces.
    thank you

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    That's Oracle's recycle bin. To get rid of the BIN$ tables use the purge command:
    http://download-uk.oracle.com/docs/c...8.htm#i2152611

    You can avoid the BIN$ table when dropping the table, read the manual for DROP TABLE (you are looking for the PURGE option):
    http://download-uk.oracle.com/docs/c...3.htm#i2061306

    Details about the recycle bin are here:
    http://download-uk.oracle.com/docs/c...s.htm#i1010137

  3. #3
    Join Date
    Dec 2008
    Posts
    5

    Thumbs down recyclebin

    when you drop any table in oracle it will reside in the recycle bin. If you want to drop that you can drop from recyclebi.

    You can see the objects that are in the recycle bin using the following query

    select * from recyclebin;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •