What is the difference between a user and a schema ?

From: Monty <mmontreaux_at_hotmail.com>
Date: 4 Oct 2002 12:41:14 -0700
Message-ID: <6284dd3.0210041141.3b55ae1f@posting.google.com>

Hi, I'm more than a little confused by the apparent similarities and differences between what is a user and what is a schema.

I have installed on my home computer Oracle 8i Enterprise.

Loading up "Oracle Enterprise Manager" I note that the default install has created a user called "SCOTT" and a schema called "SCOTT". When I create a new user called "MARY" I note that I only have a new user called "MARY", but no new schema called "MARY".

So what is the difference?
And if I wanted to create a new schema called "MARY" how would I do it?
And why would I want to do it?

Thank you
Monty Received on Fri Oct 04 2002 - 14:41:14 CDT