Home » RDBMS Server » Server Administration » USER_OBJECTS lists BIN$* objects (10gR2 on Linux 4.7)
USER_OBJECTS lists BIN$* objects [message #413255] Wed, 15 July 2009 00:54 Go to next message
jxh461
Messages: 185
Registered: March 2005
Senior Member
select object_name,object_type,status from user_objects
order by object_name
SQL> /

OBJECT_NAME OBJECT_TYPE STATUS
----------------------------------- ------------------- -------
ABOVEAVERAGEBUDGET VIEW VALID
BIN$bdQeFWglC7jgQAB/AQB3Iw==$0 TABLE VALID
BIN$bdQeFWgmC7jgQAB/AQB3Iw==$0 TABLE VALID
BIN$bdQeFWgnC7jgQAB/AQB3Iw==$0 TABLE VALID
BIN$bdQeFWgoC7jgQAB/AQB3Iw==$0 TABLE VALID
BIN$bdQeFWgpC7jgQAB/AQB3Iw==$0 TABLE VALID
BIN$bdQeFWgqC7jgQAB/AQB3Iw==$0 TABLE VALID
BIN$bnttP37PkKPgQAB/AQBHUA==$0 TABLE VALID

BRIEFMEMBERS VIEW VALID
CUSTOMERS TABLE VALID
DEPARTMENT TABLE VALID
DEPENDENT TABLE VALID
DEPT_LOCATIONS TABLE VALID
EMPLOYEE TABLE VALID
MEMBERS TABLE VALID
PRODUCTS TABLE VALID
PROJECT TABLE VALID
SALES TABLE VALID
SOMETEAMMEMBERS VIEW VALID
TEAMS TABLE VALID
WORKS_ON TABLE VALID

21 rows selected.

What are these objects. I can see that they are listed as tables but where did they come from ?
Re: USER_OBJECTS lists BIN$* objects [message #413258 is a reply to message #413255] Wed, 15 July 2009 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
These are recycle bin objects.

Regards
Michel
Re: USER_OBJECTS lists BIN$* objects [message #413261 is a reply to message #413258] Wed, 15 July 2009 00:58 Go to previous messageGo to next message
jxh461
Messages: 185
Registered: March 2005
Senior Member
Must they show up ? Are they needed for anything specific ?
Is there something I can turn on/off to not have them appear ?
Re: USER_OBJECTS lists BIN$* objects [message #413265 is a reply to message #413255] Wed, 15 July 2009 01:02 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

As Michel has mentioned, these objects were deleted. You can check RECYCLE_BIN view to view these objects. You can even select them, check whether you need them or not, if not, delete them by using PURGE command
Re: USER_OBJECTS lists BIN$* objects [message #413266 is a reply to message #413265] Wed, 15 July 2009 01:05 Go to previous message
jxh461
Messages: 185
Registered: March 2005
Senior Member
Thanks.

I Just did some reading on it as well.
Previous Topic: Capture statement with job process, but I can not, need your help!
Next Topic: Oracle allocate extent size strategy
Goto Forum:
  


Current Time: Wed Dec 11 22:42:16 CST 2024