Home » SQL & PL/SQL » SQL & PL/SQL » some just table names after dropping demo tables
some just table names after dropping demo tables [message #196496] Thu, 05 October 2006 11:19 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

when i drop demo tables in my schema i am seeing some junk table names when i query
using

select * from tab;

Result
-------
select * from tab;
TNAME TABTYPE

BIN$MqAbSqFKQjyXAx8mi7jVVw==$0 TABLE
BIN$4sGGjyYsSIyPgDAG4hGagw==$0 TABLE
BIN$ylAaTYQ/QpiymuC/GXFv0w==$0 TABLE
BIN$PgZQwJj+THKeQbwrOTQeZQ==$0 TABLE

why it is showing like that? how can i overcome it

Thanks
Re: some just table names after dropping demo tables [message #196497 is a reply to message #196496] Thu, 05 October 2006 11:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You are using 10g and these are from recycle bin.
use
sql> purge recyclebin;
Re: some just table names after dropping demo tables [message #196574 is a reply to message #196497] Fri, 06 October 2006 00:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
630,000 hits on Google...
Re: some just table names after dropping demo tables [message #196804 is a reply to message #196496] Sat, 07 October 2006 11:14 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Also Try
sql>drop table test purge
if u using "purge" clause then table not gone in recyclebin.

Previous Topic: index is in unusable state - Please help
Next Topic: how to delete rows of one column from table
Goto Forum:
  


Current Time: Wed Dec 07 12:53:37 CST 2016

Total time taken to generate the page: 0.23157 seconds