Home » RDBMS Server » Server Administration » Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ (Oracle 10g)
Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #361784] Fri, 28 November 2008 01:36 Go to next message
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
Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #361807 is a reply to message #361784] Fri, 28 November 2008 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Those are objects from recyclebin.

Regards
Michel
Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #381432 is a reply to message #361807] Fri, 16 January 2009 23:07 Go to previous messageGo to next message
rushimails
Messages: 24
Registered: November 2008
Location: Mumbai
Junior Member
How do you clear this recyle Bin ?
Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #381434 is a reply to message #361784] Fri, 16 January 2009 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #381450 is a reply to message #381432] Sat, 17 January 2009 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you should click on and read the link I provided, maybe.

Regards
Michel

[Updated on: Sat, 17 January 2009 01:18]

Report message to a moderator

Re: Some Tables Found like BIN$FCDT0+8RRMi4dzKtAH6fPQ [message #381486 is a reply to message #381450] Sat, 17 January 2009 03:13 Go to previous message
rushimails
Messages: 24
Registered: November 2008
Location: Mumbai
Junior Member
Thank you so much Michel, That was really helpful.

Rgds
Rushi
Previous Topic: Installed Database Features
Next Topic: ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Sat Dec 10 03:32:42 CST 2016

Total time taken to generate the page: 0.11668 seconds