OraFAQ Forum: Server Administration » Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ

Home » RDBMS Server » Server Administration » Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #361784]

Fri, 28 November 2008 01:36

rushimails
Messages: 24
Registered: November 2008
Location: Mumbai

Junior Member

I have created a User "x". I granted Connect, resource, IMp_full_database, exp_full_database to the user.
Now when I run query below it shows the result as below.
Can someone explain what are those tables.

SQL> SELECT * FROM TAB;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ---------
BIN$FCDT0+8RRMi4dzKtAH6fPQ==$0 TABLE
BIN$/0BoqYk9R4uDDFeg15WSCA==$0 TABLE
BIN$6oIQXluaS1euYSpEl3SWWw==$0 TABLE
BIN$tEtOrHKhStGajjbc1UgAYQ==$0 TABLE

Rgds
Rushi

Report message to a moderator

Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #361807 is a reply to message #361784]

Fri, 28 November 2008 02:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Those are objects from recyclebin.

Regards
Michel

Report message to a moderator

Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #381432 is a reply to message #361807]

Fri, 16 January 2009 23:07

rushimails
Messages: 24
Registered: November 2008
Location: Mumbai

Junior Member

How do you clear this recyle Bin ?

Report message to a moderator

Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #381434 is a reply to message #361784]

Fri, 16 January 2009 23:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How do you clear this recyle Bin ?
I am sorry to see that both the Search function on this forum & GOOGLE are broken for you.
Please wait patiently while repairs are completed.
Additional details will be posted as they become available.

Report message to a moderator