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_ vs all_

chuckersApr 23 2004 — edited Apr 23 2004

The all_<tables> were recently introduced to me. Prior to this, I thought that the dba_<tables> provided a db-wide view of object information, but I see similar information in both (as opposed to user_<tables>).

What's the difference between 'all_%' and 'dba_%' tables, for example, between all_users and dba_users?

Thanks,
Chuck

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2004

Added on Apr 23 2004

#general-database-discussions

5 comments

864 views