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!

drop table

Discussion in 'SQL PL/SQL' started by Puru, Oct 8, 2010.

  1. Puru

    Puru Forum Advisor

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    I have created a table with primary key and not null constraint, then I have droped the table then I have executed the query SELECT * FROM TAB; then in place of table name "BIN$bnwvZd+9S7aFa5euda6VCw==$0".

    How to solve this

    SQL> select * from tab;

    TNAME TABTYPE CLUSTERID
    ------------------------------ ------- ----------
    DEPT TABLE
    EMP TABLE
    BONUS TABLE
    SALGRADE TABLE
    BIN$bnwvZd+9S7aFa5euda6VCw==$0 TABLE
    BIN$6+JzKtHSTeyELwMMNEM5fA==$0 TABLE
    BIN$Ct6HJ6+zR1iCTeLuB+m+lg==$0 TABLE
    BIN$0JtXqubaRTKQVlVfH+u/tw==$0 TABLE
    EMPDEPT TABLE
    WORKS TABLE
    DEPARTMENTS TABLE

    TNAME TABTYPE CLUSTERID
    ------------------------------ ------- ----------
    BIN$B3teaMrLQHKJf+TgPh/iZQ==$0 TABLE
    BIN$BU8s/hBwTQSbO+xtgzrqJA==$0 TABLE
    FACULTY TABLE
    BIN$8pUSCdYwR8alvjLRMfnw/g==$0 TABLE
    BIN$q4J7qCYMRsSAcf7hhntodQ==$0 TABLE
    BIN$w3togXJsQLWbRLD3NJeMZQ==$0 TABLE

    17 rows selected.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Presuming you don't want to ever recover this table you can do one of the following:


    drop table <tablename> purge;

    Or you can rid yourself of all of those pesky recyclebin objects by:

    purge recyclebin;

    Or you can turn the recyclebin off entirely if you have DBA privileges:

    alter system set recyclebin=off;
     
  3. Puru

    Puru Forum Advisor

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Dear David,

    I want to remove BIN$B3teaMrLQHKJf+TgPh/iZQ==$0 TABLE from the table list.
     
  4. Puru

    Puru Forum Advisor

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Dear David,

    I have tried, its working.

    Thank you