表的架构和所有者 [英] Schema and Owner of Table

问题描述

在oracle中，表的架构和表的所有者是否相同?如果没有，有什么区别?

Is the schema for a table and the owner for a table the same in oracle? If not what is the difference?

推荐答案

为

您应将模式视为用户帐户和的集合 所有对象都作为用于所有意图和目的的模式.

You should consider a schema to be the user account and collection of all objects therein as a schema for all intents and purposes.

由用户创建的表-因此由该用户拥有，例如，在all_tables中的owner-构成该用户模式的一部分.所以，是的，所有者和架构是相同的.

A table created by a user - and therefore owned by that user, as the owner in all_tables for example - forms part of that user's schema. So yes, the owner and schema are the same.

另请参见此先前的问题，该问题引用了相同的AskTom帖子，并从中突出了这一行:

Also see this earlier question, which references the same AskTom post, and also highlights this line from it:

出于所有意图和目的，只需考虑user = schema = user = 模式=同一件事

for all intents and purposes just consider user = schema = user = schema = the same thing

这篇关于表的架构和所有者的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！