What is Oracle metadata?
来源:互联网 发布:圆方软件购买 编辑:程序博客网 时间:2024/05/31 18:53
The short answer is that metadata is data about data. In other words Oracle needs to store data to keep track of what data you're storing in the database. It also needs to store data about the physical and logical structures of the database - such as the names, locations and sizes of all the database files - as well as the instance (the memory structures and the background processes) and the operation of the database such as recently executed sql statements, execution plans, status of objects, checkpoints, log file switches etc.
In fact Oracle devotes two schemas (users) to keeping track of the database and teh data within it. These schemas are called system and sys and will store information about the database schemas that have been created, the objects owned by these schemas, the privileges they have, etc. as well as the information about the structure of the database (both logical and physical), and the operation of the database.
The metadata is stored in its own sets of tables and is usually available to end users to query via views. The views about database objects are conveniently divided into three sets:
These views present the data in a user-friendly manner and hide the complexity of the underlying tables as well as protecting the underlying tables from accidental update.
In fact Oracle devotes two schemas (users) to keeping track of the database and teh data within it. These schemas are called system and sys and will store information about the database schemas that have been created, the objects owned by these schemas, the privileges they have, etc. as well as the information about the structure of the database (both logical and physical), and the operation of the database.
The metadata is stored in its own sets of tables and is usually available to end users to query via views. The views about database objects are conveniently divided into three sets:
- those prefixed with "DBA_" which are usually only accessible by sys or system and contain data about all tables, views, indexes and other objects in the database
- those prefixed with "ALL_" which contain data about all objects in the database that your account has the privileges to access
- those prefixed with "USER_" which contain data about all objects in the database that are owned by you.
These views present the data in a user-friendly manner and hide the complexity of the underlying tables as well as protecting the underlying tables from accidental update.
0 0
- What is Oracle metadata?
- What is Oracle ASCP?
- what is the oracle cursor?
- oracle报错:ORA-39213: Metadata processing is not available
- What is DUAL table in Oracle
- What is what ?!
- what is what?
- What is SCAN in Oracle 11g R2 RAC
- 从oracle 11g导出->12c 导入 ,遇到ORA-39213: Metadata processing is not available
- 从oracle 9i导出->11g导入 ,遇到ORA-39213: Metadata processing is not available
- csharp: Oracle Metadata queries
- csharp: Oracle Metadata queries
- What is portal? & What is portlet?
- what is game? what is good game?
- What Is 'SSL'? What Is 'SSH'?
- WHAT IS C#
- What is System Administration?
- What is EDI?
- Android App Widget创建步骤
- JAVA之enum(枚举类)解析
- abercrombie pas cher
- jq+ajax获取数据库里头的省市区联动三级搜索菜单
- air max femme since 2009
- What is Oracle metadata?
- hollister france officiel Knight of the main cartridge HE box field
- abercrombie pas cher he fondly told reporters
- abercrombie milano His personal view
- 关于sychronized锁的一些研究。
- 高性能Javascript:脚本的无阻塞加载策略
- air max bw pas cher 25 on the 3rd died.August 14 morning
- 小组级git服务器搭建
- doudoune moncler femme longue most of the performance of the vicissitudes of the elderly