OraFAQ Forum: Server Administration » Briefly explain Schema in oracle

Home » RDBMS Server » Server Administration » Briefly explain Schema in oracle

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

Briefly explain Schema in oracle [message #59296]

Mon, 10 November 2003 18:00

swe
Messages: 1
Registered: November 2003

Junior Member

Hi,
Can anyone plz explain the concept of schema in the Oracle database, or else gimme links for understanding the basic architecture and wat exactly is meant by schema..your help is greatly appreciated...
thanxs
SWe

Report message to a moderator

Re: Briefly explain Schema in oracle [message #59297 is a reply to message #59296]

Mon, 10 November 2003 18:48

Maaher
Messages: 7065
Registered: December 2001

Senior Member

In fact, a schema in Oracle is the "same" as a user in Oracle. Each user has his own objects (tables, procedures, ...) and can give access rights to other users.

So the concept is: each user has his own schema, i.e. collection of objects of his own.

MHE

Report message to a moderator