用户和Oracle中的架构之间的区别? [英] Difference between a user and a schema in Oracle?
问题描述
用户和Oracle中的架构之间有什么区别?
What is the difference between a user and a schema in Oracle?
推荐答案
来自您应将模式视为用户帐户并包含其中所有对象的集合 作为用于所有意图和目的的模式.
You should consider a schema to be the user account and collection of all objects therein as a schema for all intents and purposes.
SCOTT是一种架构,其中包括具有各种授权的EMP,DEPT和BONUS表,以及 其他东西.
SCOTT is a schema that includes the EMP, DEPT and BONUS tables with various grants, and other stuff.
SYS是一个包含大量表,视图,授权等的模式.
SYS is a schema that includes tons of tables, views, grants, etc etc etc.
SYSTEM是一个架构.....
SYSTEM is a schema.....
从技术上讲-模式是数据库使用的一组元数据(数据字典), 通常使用DDL生成.模式定义数据库的属性,例如 表,列和属性.数据库模式是对数据库中数据的描述. 数据库.
Technically -- A schema is the set of metadata (data dictionary) used by the database, typically generated using DDL. A schema defines attributes of the database, such as tables, columns, and properties. A database schema is a description of the data in a database.
这篇关于用户和Oracle中的架构之间的区别?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!