OraFAQ Forum: Server Administration » USER

Home » RDBMS Server » Server Administration » USER_OBJECTS lists BIN$* objects (10gR2 on Linux 4.7)

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

USER_OBJECTS lists BIN$* objects [message #413255]

Wed, 15 July 2009 00:54

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 ?

Report message to a moderator

Re: USER_OBJECTS lists BIN$* objects [message #413258 is a reply to message #413255]

Wed, 15 July 2009 00:55

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

Senior Member
Account Moderator

These are recycle bin objects.

Regards
Michel

Report message to a moderator

Re: USER_OBJECTS lists BIN$* objects [message #413261 is a reply to message #413258]

Wed, 15 July 2009 00:58

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 ?

Report message to a moderator

Re: USER_OBJECTS lists BIN$* objects [message #413265 is a reply to message #413255]

Wed, 15 July 2009 01:02

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

Report message to a moderator

Re: USER_OBJECTS lists BIN$* objects [message #413266 is a reply to message #413265]

Wed, 15 July 2009 01:05

jxh461
Messages: 185
Registered: March 2005

Senior Member

Thanks.

I Just did some reading on it as well.

Report message to a moderator

Previous Topic:	Capture statement with job process, but I can not, need your help!
Next Topic:	Oracle allocate extent size strategy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:41:23 CST 2024