Re: What is a schema?

From: Patrice Castet <patrice.castet_at____nospaaaaam____in-fusio.com>
Date: Mon, 10 Mar 2003 10:50:28 GMT
Message-ID: <3e6c6dc1.613282843@read.news.fr.uu.net>

a schema is all objects owned by a specific user, wether it's tables, triggers, stored procs, etc.

On Mon, 10 Mar 2003 11:19:15 +0100, "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote:

>Hi!
>So far I have always thought that basically the types of all the tables in a db
>are called a schema and that you manipulate a schema by manipulating the
>table definitions.
>
>Somehow from this NG I get the idea that oracle means a lot more by the word schema.
>
>For once, schemata can belong to users, even if they share the same database. This
>contradicts my idea that everything in the db is "the schema".
>
>So, could anybody please enlighten me what a schema in oracle is and what I can do
>with it?
>
>Lots of greetings and thanks!
>Volker
>
>
Received on Mon Mar 10 2003 - 04:50:28 CST