What is system catalog?

What is system catalog?

Rating:

System catalog, also known as mini database, is nothing but a set of tables. It is created and maintained for each database. The contents of the system catalog are listed below:

• It includes the definitions of the database objects, such as tables, views, indexes, packages, etc.
• It contains security information related to the type of access that users have to the database objects.
• It contains a list of system tables.
• It stores meta-data that includes the physical layout (schema) of the database.

These tables cannot be explicitly dropped or created, but their contents can be queried and viewed. Oracle updates the tables during any database operation. The system table is often referred to as online, as it remains active and can be queried by users like any other normal table.

Rating: