Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dba_objects and all_objects

532632Dec 22 2008 — edited Dec 22 2008
Hi friends,

I know that the user_objects table is queried to list all objects in the logged in schema.

However what is the difference between all_objects and dba_objects?

I queried both these views and they fetch almost the same info.

Thanks.
This post has been answered by 591186 on Dec 22 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2009
Added on Dec 22 2008
4 comments
540 views