开发者

What is the difference between an Oracle and Microsoft schema?

Is this an accurate way to describe the difference in the meaning of schemas between the two technologies?

  • An Oracle schema is 开发者_开发问答associated with a single user and consists of the objects owned by the user.
  • A MS SQL Server schema is a namespace.


Oracle schemas are like My Documents folders in the Windows OS. A user can grant permissions to other users to see things in their schema but an Oracle schema is essentially a user's workspace.

MS SQL Server's schemas are namespaces. While you can have Accounting and Marketing schemas, they are not tightly-coupled to individual users. Objects in an Accounting schema contain accounting information and objects in the Marketing schema have marketing information.

Oracle schemas are tightly-coupled to users and MS SQL Server schemas are primarily for classification.

See this question for more information: Difference between SQL Server and Oracle user

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜