OraFAQ Forum: General » Why need a Schema

Home » Other » General » Why need a Schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why need a Schema [message #122493]

Mon, 06 June 2005 14:24

wtolentino
Messages: 429
Registered: March 2005

Senior Member

I need a simple explanation why it is needed to create a schema and it's purposes. Thanks.

Report message to a moderator

Re: Why need a Schema [message #122499 is a reply to message #122493]

Mon, 06 June 2005 15:40

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

schema is the work area for the user.
You ask oracle to create a user, it will create the user and a work area (with the same name) for that user, so that the user can organize all his objects in one area. this work area is schema.

Report message to a moderator

Re: Why need a Schema [message #122508 is a reply to message #122499]

Mon, 06 June 2005 19:53

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Otherwise everything would just be global and public. Data has to belong to somebody.

Report message to a moderator

Re: Why need a Schema [message #122513 is a reply to message #122508]

Mon, 06 June 2005 22:04

wtolentino
Messages: 429
Registered: March 2005

Senior Member

Does a schema automatically created when a user is created? Or a schema have to be manually created after a user is created?

Report message to a moderator

Re: Why need a Schema [message #122547 is a reply to message #122513]

Tue, 07 June 2005 03:59

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

In Oracle they are the same thing.

Report message to a moderator

Re: Why need a Schema [message #130824 is a reply to message #122547]

Tue, 02 August 2005 14:47

wtolentino
Messages: 429
Registered: March 2005

Senior Member

Now I understand that a schema is a logical representation of an owner account.

Report message to a moderator

Previous Topic:	Oracle Stored Procedure
Next Topic:	Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 15 12:45:59 CST 2026