It is true that we can access data dictionary thru views provided by oracle database. It directly does not expose the metadata information to user due to security issues. As far as i know, internally the metadata is stored in tables only. To protect this information from users, it provides different types of views based on role like dba_tables, all_tables, user_tables etc. In Oracle 9i, we have object types also, but they are internally stored in tables only.
if you find any info contradictory to this, please do let me know.
|