recyclebin object name behaviour

[MURALI KRISHNA]

i query the table user_objects

i got several rows but one among all rows is

6 BIN$njBRRfKAXdLgRJbjnX7A/g==$0 62594 62594 TABLE 3 /10/2011 3:08:36 PM 3/11/2011 1:27:46 PM 2011-03-11:13:27:46 VALID N N N

last butone column is "generated" its description is was the name of the object is system generated

my question is :
it is showing as "N" but the recyclebin object name is system generated one then why it is showing as "N"

it should show as "Y" for"generated column"
thanks in advance

 

[Rahul P]

MuraliKrishna,

I would imagine this question is not for this forum, but, something like this forum.
http://forums.oracle.com/forums/forum.jspa?forumID=75
orhttp://forums.oracle.com/forums/forum.jspa?forumID=61

Since the values are coming from Oracle itself, not pl/sql developer. You would get the same results even in 'SQL Developer' or any other client tool.

Either way, my guess is:

Because, the original table for the dropped object is generated by the user, not the system. That would be reason why it says 'N' for dropped objects also.

 

[Rahul P]

Also,

select * from dba_objects a where a.generated = 'Y';

would give you an idea on what the column means.

These are unnamed constraints, or, unnamed lob segments etc, while you are creating the supporting objects.