Differences between User Tables and Data Dictionary

There are some differences between User Tables and Data Dictionary. The differences are mentioned below:

• User Tables are a collection of tables which are created and maintained by the user. Every user has a specific no of tables which are only created by them and also maintained by them. But Data Dictionary is a collection of tables which are created and maintained by the Oracle Server.
• User Tables only contain user information. Whereas Data Dictionary contains database information.
• All the user tables are specified and owned by the user who created and maintained those. But all Data Dictionary tables are owned by SYS user.
• There is no such type of categories of User Tables views. But Data Dictionary has four categories of views: USER_, ALL_, DBA_ and V$.
  

These are the differences between User Tables and Data Dictionary.

© Written by meRancidTaste