1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

BIN$b files get created ...

Discussion in 'General' started by AnaghaR, Jun 25, 2009.

  1. AnaghaR

    AnaghaR Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune, Maharashtra,India
    Dear All,

    I have just installed oracle 10g on my Linux (CentOs 5.3) system.

    Whenever I am deleting any table a new table is being created with the name "BIN$b....==$0" .

    If I m trying to view the content of the table it gives me the error.

    Can anybody help me to solve this problem.

    Regards,
    Anagha
     
  2. sashraf

    sashraf Active Member

    Messages:
    11
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Hyderbad. India
    From 10g we have a concept of recyclebin.

    Table which ever you have dropped is moved to recycle bin. So you need to use purge with your drop statement.

    drop table table_name purge;

    If you dont mention purge then your table can be recovered from recycle bin just by doing create table as select. Once PURGE is added to your drop statement your table is permanently dropped.

    For reference you can check this
    http://www.adp-gmbh.ch/ora/sql/drop_table.html

    ~Ashraf
     
  3. AnaghaR

    AnaghaR Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune, Maharashtra,India
    Thank you Ashraf. Can u tell me how to delete current entry.
     
  4. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    Not too sure what you mean?

    If you mean that you want to delete the recycle bin, i would say that is not allowed.
     
  5. AnaghaR

    AnaghaR Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune, Maharashtra,India
    No I dont want to delete the recycle bin but i dont want these entries to be shown.

    Is it possible? If yes then please tell me how to do that.
     
  6. newbie_nz

    newbie_nz Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Google it and you shall find what you are looking for ... Anyway ..

    Each user has his/her own recycle bin.

    The following command shows the contents of one's recycle bin:

    select * from recyclebin;
    OR
    show recyclebin

    Use the purge SQL command to purge something in the recycle bin.

    purge tablespace USERS;

    PURGE TABLESPACE <tablespace_name>
    USER <schema_name>;

    Another way to show what's in the recyclebin ...

    SELECT object_name, original_name, ts_name
    from dba_recyclebin;
     
  7. sashraf

    sashraf Active Member

    Messages:
    11
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Hyderbad. India
    If you want to delete a single table from recyclebin then you can first so a select on recyclebin get that table name and drop it using purge command
    when you execute
    show recyclebin; you will get
    ORIGINAL NAME RECYCLEBIN NAME TYPE DROP TIME

    from this you can copy RECYCLEBIN NAME and use purge on that always that name will start with BIN$....

    purge table BIN$....;

    http://wiki.oracle.com/page/4+DROP+TABLE
    I think this will solve all your doubts.

    ~Ashraf
     
  8. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    To remove all objects from recyclebin,

    conn / as sysdba

    and then

    PURGE DBA_RECYCLEBIN;

    You can also remove particular objects from particular tablespace or even from particular users.

    Note that it all depends on recyclebin parameter.
    For more information have a look at,
    Delete an Object permanently from oracle