您好,欢迎光临! 请 |

What is the schema ?

作者: | 分类:FAQ | Tag: | 评论:1 
字号:T|T

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.

objects from different schemas, and the objects for a schema can be contained in
different tablespaces.
顶一下
(0)
100%
踩一下
(0)
100%

原创内容,转载时请保留原文信息:
文章标题:What is the schema ?
↑上一篇↑:
↓下一篇↓:

1 篇回应 (访客:1 篇, 博主:0 篇)

  1. Rix Chan 2014-23-03

    schema和user 有没有明显区别呀?

    #-49楼

插入图片

NOTICE1:请申请gravatar头像,没有头像的评论可能不会被回复|头像相关帮助!