Home » SQL & PL/SQL » SQL & PL/SQL » cannot drop table
cannot drop table [message #224907] Thu, 15 March 2007 22:21 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
iam using oracle 10g version 10.1.0.2.0
i am unable to drop this table

DROP TABLE "BIN$/+oIYNVrRZyVH6cT2IxYWw==$0"
ORA-27235: Message 27235 not found; product=RDBMS; facility=ORA
its urgent pls respond

thanxs
Re: cannot drop table [message #224909 is a reply to message #224907] Thu, 15 March 2007 22:28 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>its urgent pls respond
Why is it urgent for me to solve this problem for you?
I don't think you have any need to drop this table.
Re: cannot drop table [message #224941 is a reply to message #224909] Fri, 16 March 2007 01:40 Go to previous messageGo to next message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
'BIN$/+oIYNVrRZyVH6cT2IxYWw==$0' is in recycle bin (object you have dropped). To get rid of it, just purge recycle bin using
SQL> purge recyclebin;


P.S. Just being curious: what makes dropping that garbage URGENT?

[Updated on: Fri, 16 March 2007 01:41]

Report message to a moderator

Re: cannot drop table [message #226450 is a reply to message #224907] Fri, 23 March 2007 15:41 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Try ' purge recyclebin'
Previous Topic: How to view a table in 10g Express?
Next Topic: searching for a string in a string
Goto Forum:
  


Current Time: Mon Dec 05 04:34:26 CST 2016

Total time taken to generate the page: 0.11012 seconds