What is the schema ?

edwards0307

于 2011-12-20 15:18:24 发布

阅读量277

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/edwards0307/article/details/84117573

oracle 专栏收录该内容

33 篇文章

订阅专栏

本文深入探讨了数据库中模式的概念，解释了模式与用户的对应关系，并详细说明了哪些对象属于模式，哪些不属于，以及模式与表空间之间的区别。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

A schema is a collection of database objects owned by a specific database user,or schema objects.Schema has the same name as that user,every user has a single schema,so the two terms(Schema,User) are synonymous.

Schema objects include the segments(tables,indexes..etc) as we can see in the tablespaces as well as the nosegments database objects(constraints,views,procedures,synonyms and packages).But the roles,tablespaces,profiles and directories are not schema objects,cause they are not owned by one specific user.

In a word,if any object(table,view,index…) owned by one user,it’s schema object.Contrarily,the role,profile,tablespace and directory (not owned by one user) are not schema objects.

Note:

There is no relationship between schemas and tablespaces: a tablespace can contain objects from different schemas,and the objects for a schema can be contained in different tablespaces