I dunno if this Oracle's bug or i am missing out somewhere.
querying USER_OBJECT_SIZE gives me various things including the code size for procedural objects created in system tablespace.It puts 0(zero) if we try to see the code size of a table but.I agree as table is not the procedural object.
The noticable things is: when i run
select * from USER_OBJECT_SIZE;
it lists down soem tables and leaves others.Like it lists down emp table but leaves dept table.You can really see it.
My question is why is it happening? Any specific reason?
Thanks and regards,