True, as far as Oracle is concerned.

The confusion probably stems from the fact that Oracle did not invent the term 'Schema', AFAIK. And if they did, it has since been twisted.

From the application side of the house, the database schema is the same as the model is the same as the set of objects that the application uses, whether that is through views, tables or synonyms, regardless of who owns them. Furthermore, when I log into the application as a user, the schema is 'what I can see' as a user, which can be different from the application's definition of the 'schema' and different still from the database's definition of the schema.

From Oracle's perspective, the term 'schema' is as sreddy defined it, AKAIK, the set of objects actually created by ( or owned by) a given user.

HTH,

- Chris