One of the most important parts of database is its data dictionary , which is read only set of tables that provide information about the database.
A Data Dictionary Table Contains:
1.Integrity Constraints Information.
2.The Names of the Oracle Users.
3.Privileges and Roles each user has been granted.
4.Auditing Information such as who has accepted or updated various schema Objects.
5.Other general database information the data dictionary is structured in tables & views just like other databases
All the Data Dictionary Tables & views for a given Database are stored in that databases System table space.
****All DDL commands are auto commitable****
A Data Dictionary Table Contains:
1.Integrity Constraints Information.
2.The Names of the Oracle Users.
3.Privileges and Roles each user has been granted.
4.Auditing Information such as who has accepted or updated various schema Objects.
5.Other general database information the data dictionary is structured in tables & views just like other databases
All the Data Dictionary Tables & views for a given Database are stored in that databases System table space.
****All DDL commands are auto commitable****
No comments:
Post a Comment
If you Like my blog Spread it and help friends for whom this blog is useful for their career.